What are the differences between drop a table and truncate
a table?
Answer Posted / sudha
Truncate Table - Truncate table is the combination of Drop
and Create. It [Truncate]can drop and recreate the table.
Delete - Delete will deletes all the data in the table and
structure of the table.
| Is This Answer Correct ? | 4 Yes | 20 No |
Post New Answer View All Answers
What is meant by mysqli?
How many mysql connections can handle?
How do you flush privileges?
What is deterministic in mysql?
What is clob datatype?
How do I fix a crashed mysql database?
Can mongodb replace mysql?
How do you backup a database in mysql?
What is row level locking in access?
Why do we use pragma autonomous transaction?
Is there a way to see the files which are stored?
What is a procedure example?
What are the types of database engines available in mysql?
How do you concatenate strings in mysql?
What is mysql routine?