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

Answer Posted / ......v......

TRUNCATE <table_name>;
This will only Remove table data and not structure of table

DROP <table_name>;
This will Remove table data and structure both

In both the cases data can be Rollbacked in SQL Server 2000
or 2005.....,But NOT POSSIBLE in other.........!

Is This Answer Correct ?    10 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of mysqli_num_rows?

698


Which is faster innodb or myisam?

728


What is a csv table?

766


How do I create a schema in mysql?

664


What is row level locking in access?

668


What is difference between mysql and mysql workbench?

662


What is schema in mysql?

691


How to make a copy values from one column to another in mysql?

809


What is the difference between unix timestamps and mysql timestamps?

752


What are the functions of commit and rollback statements?

739


Is primary key auto increment?

709


What mysql means?

692


What's new in mysql 8?

771


Explain csv tables.

728


What is a deterministic function?

816