What are the differences between drop a table and truncate
a table?
- 10 Answers
- 24242 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 setup mysql?
Is mysql good for large database?
What is the difference between MyISAM Static and MyISAM Dynamic?
What is the default port for MySQL Server?
What is information_schema in mysql?
Do you need a license for mysql?
What is the phantom problem?
Does mysql use t sql?
How many sql dml commands are supported by 'mysql'?
Why use stored procedures in mysql?
How to create a new table by selecting rows from another table in mysql?
Explain the difference between procedure and function in mysql?
How do I download mysql on my laptop?
Why do we use pragma autonomous transaction?
what is a cursor? : Mysql dba
