Explain drop and truncate table command.
TRUNCATE:TRUNCATE removes all rows from a table.
The operation cannot be rolled back and no triggers will be fired.
The following example will show what a TRUNCATE does:
SQL> TRUNCATE TABLE emp;
Table truncated.
DROP: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.
The following example will show what a DROP does:
SQL> DROP TABLE emp;
Table dropped
