Searching...
Thursday, 11 April 2013

Comparison of SQL Delete, Truncate and Drop

00:52


Delete

  1. It is a DML statement
  2. Rollback is possible after execution
  3. Triggers can fire out
  4. Where clause can use for condition
  5. Table structure will exists

Truncate

  1. It is a DDL statement
  2. Rollback not possible
  3. Trigger fire out not possible
  4. Cant apply where clause
  5. It is very fast compare to delete
  6. Table structure will exists

Drop

  1. Table structure will not exists 
  2. Roll back not possible

0 comments: