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
How do I download mysql on my laptop?
How to drop an existing table in mysql?
How do I find users in mysql?
Is mariadb better than mysql?
How can I see connections in mysql?
How do I show users in mysql?
How do I change directories in mysql?
Is mysql free for enterprise?
How to rename an existing table in mysql?
Can mongodb replace mysql?
How do you know the version of your mysql server?
How to get help information from the server?
How do I rename a table in mysql workbench?
How do I clear the command in mysql?
What is difference between oracle and mysql?