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

Answer Posted / ramavtar rajput

drop--> means table is delete ,not roll back,

truncate-->

Is This Answer Correct ?    18 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between a heap table and temporary table?

569


How many entries can mysql handle?

589


How do I stop a mysql service?

604


What is mysql server?

577


How do you determine the location of mysql data directory?

573






How to check server status with 'mysqladmin'?

618


How we get sum of column.

592


How can you count the total number of records of any table?

586


What is procedures in mysql?

581


What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

592


How do I run a query in mysql?

561


Why do we use the mysql database server?

608


What is session variable in mysql?

582


What is slow query log in mysql?

620


What is logs in mysql?

555