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. In the Databases folder in Enterprise Explorer, under the database connection profile, expand the navigation tree for the appropriate database and schema owner.
    Database Steps
    From an ASE connection profile
    1. Expand the Databases folder.
    2. Expand the tree for a database and then the tree for the appropriate schema owner.
    From a SQL Anywhere or Sybase IQ connection profile
    1. Expand the tree for a database.
    2. Expand the Schemas folder and then the tree for the appropriate schema owner.
  2. Expand the Tables folder, right-click the table for which you want to delete all data rows, and select Truncate Table.
  3. 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

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com