The TRUNCATE command is use to removes all rows from a table.
Truncate table [table_name]
The DELETE statement is used to delete rows in a table.
Delete from customer where name = 'Ramesh' and address = 'Ahmedabad'
Delete From customer //Delete All Records
The DROP TABLE statement is used to delete a table.
DROP TABLE table_name
The DROP DATABASE statement is used to delete a database.
DROP DATABASE database_name
The DELETE command is used to remove rows from a table, WHERE clause can be used to remove specified rows. If no WHERE condition is specified, all rows will be removed.
After performing a DELETE operation you need to COMMIT or ROLLBACK the transaction to make the change permanent or to undo it.
TRUNCATE removes all rows from a table. The operation cannot be rolled back and no triggers will be fired. As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.
The DROP command removes a table from the database. All the tables' rows, indexes and privileges will also be removed. No DML triggers will be fired. The operation cannot be rolled back.