difference between TRUNCATE, DELETE and DROP in SQL Server

DELETE Command

 1. DELETE is a DML command.

 2. DELETE is more slower than TRUNCATE command.

 3. DELETE maintain the logs before execute command. So its slower.

 4. In DELETE case, data rollback passable because it's maintain log file. 

 5. If we execute DELETE command that time tiger fired.

 6. In DELETE, we can use the WHERE clause.

      Example.  DELETE FROM AppLog WHERE LogId=1

TRUNCATE  Command

1.   TRUNCATE is a DDL command.
2.   TRUNCATE is more faster than DELETE command.
3.   TRUNCATE not maintain logs so it's faster.
4.   In TRUNCATE  case, data rollback not passable because it's not maintain log file .
5.   If we execute TRUNCATE command that time tiger not fired.
6.   In TRUNCATE , we can't use the WHERE clause.

     Example. TRUNCATE TABLE AppLog

DROP  Command

  1. DROP  is a DDL command.
  2. In case of DROP  command, TABLE delete permanently that menace all the table's  rows, indexes and privileges will  be removed from database.

  Example. DROP TABLE AppLog