Drop - will Delete the table date as well as the table structure. Truncat

What are the differences between drop a table and truncate
a table?

Question Posted / velmurugan

Answer Posted / velmurugan

Drop - will Delete the table date as well as the table
structure.
Truncate - Will Delete the table data only. The table
structure will remains.

Is This Answer Correct ?

71 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Is mysql and sql are same?

1073

What are the steps required to view your mysql database?

1090

What is root password?

915

What is view in mysql?

972

What is mysql database used for?

1032

What is ISAM?

1115

What is mysql port?

1060

Does facebook still use mysql?

932

How do I connect to mysql database?

1043

What is mysql connection limit?

932

How internally data stores in MyISAM and INNODB table types?

2738

What is mysql architecture?

1009

How do you determine the location of mysql data directory?

936

Explain the difference between procedure and function in mysql?

992

Can mysql handle billions of records?

1068