To delete all rows from a table, without deleting the table definition.
TRUNCATE TABLE [ owner.]table-name
Anywhere.
Must be the table owner or have DBA authority.
Delete triggers are not fired by the TRUNCATE TABLE statement.
The TRUNCATE TABLE statement deletes all rows from a table. It is equivalent to a DELETE statement without a WHERE clause, except that no triggers are fired as a result of the TRUNCATE TABLE statement and 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 triggers 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.
Delete all rows from the department table.
TRUNCATE TABLE department