Thursday, 25 February 2016

DIFFERENCE BETWEEN TRUNCATE AND DELETE

                   TRUNCATE                                                  DELETE

  1. It is a DDL command                                     1.It is a DML command
  2. It is Permanent deletion                                  2.It is Temporary Deletion
  3. It is possible to delete a specific record.         3.it is possible to delete a specific record
            
Posted by at

No comments:

Post a Comment

If you Like my blog Spread it and help friends for whom this blog is useful for their career.

Subscribe to: Post Comments (Atom)