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
What are the mysql database files stored in system ?
How do I use mysql?
How do I remove a user from mysql?
What are string data types?
what is cte? : Mysql dba
What can I do with mysql?
What is max connection in mysql?
What is the difference between unix timestamp and mysql timestamp?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
How to drop an existing index in mysql?
How to show table names with 'mysqlshow'?
What do you understand by mysql terminal?
How do I edit a table in mysql?
What is the latest version of mysql?
Is postgresql better than mysql?