What are the differences between drop a table and truncate
a table?
- 10 Answers
- 23250 Views
- I also Faced
- E-Mail Answers
Answer Posted / shital
Delete - delete all the data from table but structure still remains as it is.
Truncate - delete all data from table but structure remains and memory still allocated for table.
Drop - delete all data as well as structure and also free the memory.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is mysql primary key?
Is null in mysql?
what is the difference between gui testing and database testing? : Mysql dba
What is cast in mysql?
What do ddl, dml, and dcl stand for?
How can you handle the –secure-file-priv in mysql?
What is the use of mysql_close()?
In how many ways we can retrieve data in the result set of mysql using php?
How do I rename a table in mysql?
Why do we use the mysql database server?
What is difference between mysql and mysql workbench?
What is mysql vs sql?
How do I select a table in mysql?
How many TRIGGERS are allowed in MySql table?
How to change the database engine in mysql?
