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
Can we store files in mysql?
How to define numeric 9(3) in db2 table without decimal point??
Can I install mysql on mac?
Where the database is stored in mysql?
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
What are the advantages of mysql in comparison to oracle?
How do we use % when performing a search query?
What is 'mysqlimport'?
How to delete a table.
How to calculate the difference between two dates?
How do I view tables in mysql workbench?
What is the role of a limit in a mysql query?
How to delete a database from mysql server.
How do I kill a mysql connection?
What is the difference between b-tree and hash indexes?