What is the difference among “dropping a table”, “truncating a table” and “deleting all records” from a table.
Drop Table - will remove the existence of the table from the database along with its data and structure and all the constraints. The table will be no longer available.
Truncate Table - will remove all the rows (only the rows) from a table. it will not delete the table. Its a DDL statement that means the deleted rows cannot be reverted back by ROLLBACK statement;
Delete Table - is a DML statement which will delete rows from a table according to the matching criteria mentions in the ‘where’ clause. And these rows can be reverted back by ‘ROLLBACK’ statement if ‘COMMIT’ is not fired.