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. drop table simply drop the table and truncate first drop the table and again recreate the table structure............

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

    ReplyDelete