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.

1 comment:

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

    ReplyDelete