Deletes all rows from a table without deleting the table definition.
TRUNCATE TABLE [ owner.]table-name
Deletes all rows from the department table:
TRUNCATE TABLE department
TRUNCATE TABLE is equivalent to a DELETE statement without a WHERE clause, except that each individual row deletion is not entered into the transaction log. After a TRUNCATE TABLE statement, the table structure and all of the indexes continue to exist until you issue a DROP TABLE statement. The column definitions and constraints remain intact, and permissions remain in effect.
The TRUNCATE TABLE statement is entered into the transaction log as a single statement, like data definition statements. Each deleted row is not entered into the transaction log.
None.
Must be the table owner or have DBA authority.
For both temporary and base tables, you can execute TRUNCATE TABLE while other users have read access to the table. This behavior differs from Adaptive Server Anywhere, which requires exclusive access to truncate a base table. Sybase IQ table versioning ensures that TRUNCATE TABLE can occur while other users have read access; however, the version of the table these users see depends on when the read and write transactions commit.
Chapter 10, “Transactions and Versioning” in Sybase IQ System Administration Guide
