What are the differences between drop a table and truncate
a table?
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
Is mysql a relational database?
How can you import tables from a sql file into a database by using the mysql client?
What are the technical specifications of mysql?
What is MySQL?
Write a query to find duplicate rows in table?
What are features of mysql?
How to dump a table to a file with 'mysqldump'?
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
What is mysqli procedural?
Explain about reporting services of MYSQL?
What is max connection in mysql?
What is difference between oracle sql and mysql?
What is new mysqli?
How do I backup mysql database on linux?
What is the latest version of mysql?