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.

Are you

SQL TRUNCATE TABLE

DELETE TABLE vs TRUNCATE TABLE

TRUNCATE TABLE Vs DROP TABLE

Syntax to truncate the table from the database:

Example of truncate sql statement:

Courses