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

Answer Posted / shital

Delete - delete all the data from table but structure still remains as it is.
Truncate - delete all data from table but structure remains and memory still allocated for table.
Drop - delete all data as well as structure and also free the memory.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you take the backup and restore a mysql database using php?

694


What command is used to delete the data from the table without deleting the table structure?

664


How do I assign a variable in mysql?

688


How to convert character strings to numeric values?

827


What are the different tables present in MySQL?

815


How do I insert multiple rows in a table?

663


What is full text indexing in mysql?

719


How to analyze tables with 'mysqlcheck'?

917


What is the difference between mysql and oracle?

748


How to Join tables on common columns.

844


How can you increase the performance of mysql select query?

685


Describe mysql transaction properties.

726


What is offset limit?

720


What does do in mysql?

660


Explain the different types of constraints?

705