What are the differences between drop a table and truncate
a table?
Answer Posted / shital
Delete - delete all the data from table but structure still remains as it is.
Truncate - delete all data from table but structure remains and memory still allocated for table.
Drop - delete all data as well as structure and also free the memory.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is strict mode in mysql?
What is “i_am_a_dump” flag in mysql?
How to dump a table to a file with 'mysqldump'?
What is a deterministic function?
What is a table schema?
What is the difference between now() and current_date()?
How do I select a database in mysql?
Why do you think it is advised to not to use guid and character columns as clustered index arrays?
How to make a column bigger and delete unique from table.
I want to start and stop mysql on windows? How do I do that?
What are the technical specifications of mysql?
Is sqlite faster than mysql?
What is truncate command?
How to get current MySQL version?
How to convert character strings to dates?