What are the differences between drop a table and truncate
a table?
- 10 Answers
- 23244 Views
- I also Faced
- E-Mail Answers
Answer Posted / velmurugan
Drop - will Delete the table date as well as the table
structure.
Truncate - Will Delete the table data only. The table
structure will remains.
| Is This Answer Correct ? | 71 Yes | 9 No |
Post New Answer View All Answers
Where’s database data actually stored? Is there a way to see the files which are stored?
Where is the myisam table stored?
How will you export tables as an xml file in mysql?
How can I connect mysql database?
What is datadir?
How does triggers work in mysql?
Explain about the architecture of MYSQL?
How do I stop a query in mysql workbench?
How can we run batch mode in mysql?
How would concatenate strings in mysql?
What is a string in mysql?
What is pdo in mysql?
How many queries can mysql handle?
How to rename an existing column in a table?
Is there a way to see the files which are stored?
