1.

What Is The Difference Between Delete, Truncate And Drop Command?

Answer»

The difference between the Delete, Truncate and DROP command is:

  • Delete command is a DML command, it is USED to delete rows from a table. It can be rolled back.
  • Truncate is a DDL command, it is used to delete all the rows from the table and free the space containing the table. It cant be rolled back.
  • Drop is a DDL command, it removes the complete DATA along with the table structure(unlike truncate command that removes only the rows). All the tables’ rows, indexes, and privileges will also be removed.

The difference between the Delete, Truncate and Drop command is:


Discussion

No Comment Found

Related InterviewSolutions