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 definition.
Showing posts with label What are the differences between DROP a table and TRUNCATE a table?. Show all posts
Showing posts with label What are the differences between DROP a table and TRUNCATE a table?. Show all posts
Saturday, May 16, 2009
What are the differences between DROP a table and TRUNCATE a table?
Subscribe to:
Posts (Atom)
