Data Deletion Methods

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

To remove data from a database:

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 SAP Sybase IQ stores versions of data pages.

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