Use the truncate TABLE statement to delete table data

Use the truncate TABLE statement to delete table data
To delete all records in a large table, run the truncate command to release
The data block tablespace used. This operation cannot be rolled back.
Syntax format:
Truncate table table_name
Table_name indicates the name of the table to be deleted. Because the truncate TABLE statement deletes a table
And cannot be recovered.
Use truncate table to delete all rows in the specified table.
Bundle and index remain unchanged. The truncate table function and does not contain the WHERE clause
The delete statement is the same. Both delete all rows in the table. However, truncate table execution speed
Faster than Delete.
The table referenced by the foreign key (foreign key) constraint cannot be deleted using the truncate table.
Instead of using the WHERE clause. In addition, truncate table
The table cannot be used to index the view.