Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between drop a table and truncate
a table?
- 10 Answers
- 26220 Views
- I also Faced
- E-Mail Answers
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 start mysql client?
What is delimiter in mysql?
How to copy data from one server to another using php?
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
What is bigint in mysql?
Is mysqli faster than mysql?
What mysql -u john -p command does?
Is foreign key indexed mysql?
How to rename an existing table in mysql?
How do I start mysql manually?
What is the data source name for mysql?
How to execute mysql query in php?
How to run 'mysql' commands from a batch file?
What is difference between mysql and mariadb?
How to calculate the difference between two dates?
