Truncating Table Data

Truncating a table deletes all data rows.

Prerequisites 

Before you can delete all table rows, connect to the database server through a connection profile.

  1. Expand the Tables folder, right-click the table for which you want to delete all data rows, and select Truncate Table.
  2. Select Yes to confirm that you want to delete all rows of table data.
Related concepts
Table Data Editor
Related tasks
Creating a Table
Dropping a Table
Renaming a Table
Creating an ASE Nonsharable Temporary Table
Creating a SQL Anywhere or a Sybase IQ Temporary Table
Granting and Revoking Table Permissions
Editing Table Data
Extracting Table Data
Filtering Table Data

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.