Ways to Delete Data

Use the DELETE, DROP TABLE, and TRUNCATE TABLE statements to delete data.

To remove data from a database, you can do any of the following:

Use the DELETE statement to remove from a table all rows that meet the criteria you specify.
Use the DROP TABLE statement to remove an entire table, including all data rows.
Use the TRUNCATE TABLE statement to delete all rows from a table, without deleting the table definition.

Space for Deletions

When you use the DELETE or TRUNCATE TABLE statement, you may need to add space to your database, due to the way Sybase IQ stores versions of data pages.

When you use DROP TABLE, you do not need to add space, as no extra version pages are needed.