Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between drop a table and truncate
a table?
- 10 Answers
- 25493 Views
- I also Faced
- E-Mail Answers
Answer Posted / meena bisht
Drop: drop means it will drop the table including structure
and free the memory from hard disk.
Truncate: Truncate will truncate the data. The structure
will remain there and also will free the memory.
| Is This Answer Correct ? | 33 Yes | 4 No |
Post New Answer View All Answers
How do I rename a table in mysql workbench?
How to write after insert event update trigger on the same table in mysql?
How to shut down the server with 'mysqladmin'?
How many TRIGGERS are allowed in MySql table?
Is sql and mysql same?
How do I change global variables in mysql?
What is the datatype of image in mysql?
Write a program using the select statement, while loop.
Can mysql scale horizontally?
Is mysql free for commercial use?
How can we change the data type of a column of a table?
What is the role of a limit in a mysql query?
Is mysql from oracle?
What is difference between microsoft sql and mysql?
State the differences between mongodb and mysql.
