What are the differences between drop a table and truncate
a table?
- 10 Answers
- 24064 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
Explain csv tables.
How do you name a table?
What is memory table?
How do I run mysql?
How do you rename a procedure in mysql?
Which statement is used in a select query for partial matching?
How do I delete a mysql user?
What does mysql flush hosts do?
Write a query to display even rows in student table using mysql?
Does mysql need a server?
What can I do with mysql?
What is identity in mysql?
Explain % and _ inside like statement?
What does it mean to be case sensitive?
In which language mysql has been written?
