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.
For syntax of these statements, see Chapter 1, “SQL Statements,” in Reference: Statements and Options.
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. For details, see “Overlapping versions and deletions”.
When you use DROP TABLE, you do not need to add space, as no extra version pages are needed.
