Differences between DROP a table and TRUNCATE a table?

January 10, 2010 | Filed Under PHP | Comments Off

DROP: This will delete the table structure and its data.

syntax-DROP TABLE table_name

TRUNCATE: This will delete the table  data but not its structure.
syntax-TRUNCATE TABLE table_name

Comments

Comments are closed.

© PHPInterviewQuestion.com 2009 - 2012

eXTReMe Tracker