Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between drop a table and truncate
a table?
- 10 Answers
- 25950 Views
- I also Faced
- E-Mail Answers
Answer Posted / meena bisht
Drop: drop means it will drop the table including structure
and free the memory from hard disk.
Truncate: Truncate will truncate the data. The structure
will remain there and also will free the memory.
| Is This Answer Correct ? | 33 Yes | 4 No |
Post New Answer View All Answers
What are the advantages of MySQL when compared with Oracle?
What is striped backup
What is blob and clob?
What are the functions used to encrypt and decrypt the data present in mysql?
what is cte? : Mysql dba
What are the types of database engines available in mysql?
Which is faster mysql or mongodb?
How to analyze tables with 'mysqlcheck'?
How to write date and time literals?
What is the usage of ENUMs in MySQL?
Is mysql distributed?
How can I create table in mysql?
What is the latest mysql?
What is the latest mysql version?
Can mysql handle big data?
