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

What is difference mysql and mysqli?

718


How to get current MySQL version?

796


What is delimiter in mysql stored procedure?

678


How to use sum function in where clause in mysql?

703


What is the difference between having and where clause in mysql? Explain

754


How can you increase the performance of mysql select query?

674


How do I install mysql?

673


What is select query in mysql?

674


What is view in mysql?

753


What is the use of mysql_fetch_array () function in php?

660


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

780


How many primary keys can be there in a table?

728


Can varchar be primary key?

689


Why we use mongodb instead of mysql?

704


What happens if null values are involved in expressions?

789