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

Answer Posted / karthik

truncate means it will truncate the data, we can retrieve
it whenever we want using commit
drop - it delete the full structure as well as the data.
cant make a recovery.

Is This Answer Correct ?    2 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where is mysql installed on linux?

706


What is regex in mysql?

782


How Switch (select or use) to a database.

804


What is the difference between mysql and oracle?

755


How do I use mysql?

690


write a query to mysql in safe mode and to change the root password

764


Will mysql remain free?

722


How to Join tables on common columns.

863


How to use sum function in where clause in mysql?

725


How to make a column bigger and delete unique from table.

690


What is mysql aggregate functions? Explain

784


What happens if you no create privilege in a database?

811


How to dump one database for backup.

710


How can I create database in mysql?

716


How many columns can you create for an index?

701