What are the differences between drop a table and truncate
a table?
- 10 Answers
- 24208 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
How Switch (select or use) to a database.
What is MySQL?
How do I start mysql in ubuntu?
What does mysql flush hosts do?
What is 1nf 2nf 3nf?
How to include numeric values in sql statements?
Is mariadb faster than mysql?
Is mysql server free?
How to concatenate two character strings?
What is pdo mysql?
How is oracle different from mysql?
Write a query to display current date and time?
What is text in mysql?
How to return query output in xml format?
Is pdo more secure than mysqli?
