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

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com