Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between drop a table and truncate
a table?
- 10 Answers
- 25565 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 to write date and time literals?
What does mysql workbench do?
What is a transaction? Describe mysql transaction properties.
How do you stop an access query?
What is the usage of "i-am-a-dummy" flag in mysql?
What is sharding in mysql?
How do you rename a table in mysql?
What happens if null values are involved in expressions?
What is difference mysql and mysqli?
How do you kill a long running query in mysql?
How to dump a table to a file with 'mysqldump'?
What is the current root password of mysql?
What are date and time data types?
What is a left join mysql?
How to create a new view in mysql?
