Explain the difference between DELETE , TRUNCATE and DROP commands?

Posted by

To view Verified answers click on the button below.

Once delete operation is performed, Commit and Rollback can be performed to retrieve data.
Once truncate statement is executed, Commit and Rollback statement cant be performed.
Where condition can be used along with delete statement but it cant be used with truncate statement.
Drop command is used to drop the table or keys like primary,foreign from a table.