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 a relational database?

786

How can you import tables from a sql file into a database by using the mysql client?

971

What are the technical specifications of mysql?

1093

What is MySQL?

942

Write a query to find duplicate rows in table?

859

What are features of mysql?

844

How to dump a table to a file with 'mysqldump'?

966

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

964

What is mysqli procedural?

915

Explain about reporting services of MYSQL?

1016

What is max connection in mysql?

876

What is difference between oracle sql and mysql?

960

What is new mysqli?

863

How do I backup mysql database on linux?

890

What is the latest version of mysql?

935