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

How do I download mysql on my laptop?

674


How to drop an existing table in mysql?

754


How do I find users in mysql?

814


Is mariadb better than mysql?

772


How can I see connections in mysql?

705


How do I show users in mysql?

754


How do I change directories in mysql?

689


Is mysql free for enterprise?

699


How to rename an existing table in mysql?

751


Can mongodb replace mysql?

723


How do you know the version of your mysql server?

796


How to get help information from the server?

768


How do I rename a table in mysql workbench?

713


How do I clear the command in mysql?

716


What is difference between oracle and mysql?

713