What are the differences between drop a table and truncate
a table?
- 10 Answers
- 23248 Views
- I also Faced
- E-Mail Answers
Answer Posted / karthik
truncate means it will truncate the data, we can retrieve
it whenever we want using commit
drop - it delete the full structure as well as the data.
cant make a recovery.
| Is This Answer Correct ? | 2 Yes | 10 No |
Post New Answer View All Answers
What is ndb in mysql?
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
What are all the Common SQL Function?
How To see all the tables from a database of mysql server.
Explain triggers and stored procedures?
What is the role of a limit in a mysql query?
Is mysql a server?
How can you retrieve a particular number of records from a table?
Does mysql use t sql?
What is mysql database extension?
How database are managed?
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
How do you flush privileges?
How to escape special characters in sql statements?
How many entries can mysql handle?
