SQL TRUNCATE TABLE
To remove all rows (full data) from a table, use the truncate SQL query. It's similar to a DELETE statement that doesn't have a WHERE clause.
DELETE TABLE vs TRUNCATE TABLE
The DELETE TABLE command is slower and requires more resources than the TRUNCATE TABLE command.
TRUNCATE TABLE Vs DROP TABLE
The Drop table command can be used to delete a whole table, but it also deletes the table structure. TRUNCATE TABLE does not remove the table's structure.
Syntax to truncate the table from the database:
TRUNCATE TABLE table_name;
Example of truncate sql statement:
TRUNCATE TABLE Employee;
Notes: After the truncate table statement, the rollback process is not available. You can't use a flashback table statement to get the contents of a table once it's been truncated.
NextCourses
