RSS Feed

Difference between SQL TRUNCATE & SQL DROP

SQL - Difference between TRUNCATE & DROP

DROP TABLE - deletes the table from the database. TRUNCATE TABLE - empties it, but leaves the structure for future data.

2 comments:

  1. pavanAugust 11, 2017 at 7:19 AM

    drop table simply drop the table and truncate first drop the table and again recreate the table structure............

    ReplyDelete
  2. UnknownDecember 5, 2017 at 2:33 AM

    simply,
    Drop is deleting the table and its structure
    Truncate table empty table data

    ReplyDelete

Subscribe to: Post Comments (Atom)