Your Ad Here

Saturday, November 7, 2009

What are the differences between DROP a table and TRUNCATE a table?

DROP TABLE table_name – This will delete the table and its data.
TRUNCATE TABLE table_name – This will delete the data of the table, but not the table

No comments:

Post a Comment

Your Ad Here