TRUNCATE, DROP AND RENAME

Truncate Command- This command removes all entries from a table but doesn’t remove the table structure.
This command is different from DELETE command which can delete only one row present in table.
Using truncate command is like to initialize a table as new.

truncate table table-name

this command delete all the data present in table-name without removing its attribute.

_______________________________________________________________________

DROP Command – Drop command is used to remove a complete table from from database.
Syntax will be-

drop table table-name

This will remove complete table structure and its records from database.

_____________________________________________________________________

RENAME Command – This command is used to rename a particular table :
Syntax follows –

rename table old-table-name to new-table-name