Anil Singh | Code-sample.com

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    TRUNCATE is a DDL command.    TRUNCATE is more faster than DELETE command.    TRUNCATE not maintain logs so it's faster.   In TRUNCATE  case, data rollback not passable because it's not maintain log file .    If we execute TRUNCATE command that time tiger not fired.   In TRUNCATE , we can't use the WHERE clause.      Example. TRUNCATE TABLE AppLog DROP  Command   1. DROP  is a DDL comm...