What are the differences between drop a table and truncate
a table?
Answer Posted / ......v......
TRUNCATE <table_name>;
This will only Remove table data and not structure of table
DROP <table_name>;
This will Remove table data and structure both
In both the cases data can be Rollbacked in SQL Server 2000
or 2005.....,But NOT POSSIBLE in other.........!
Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
What is the use of mysqli_num_rows?
Which is faster innodb or myisam?
What is a csv table?
How do I create a schema in mysql?
What is row level locking in access?
What is difference between mysql and mysql workbench?
What is schema in mysql?
How to make a copy values from one column to another in mysql?
What is the difference between unix timestamps and mysql timestamps?
What are the functions of commit and rollback statements?
Is primary key auto increment?
What mysql means?
What's new in mysql 8?
Explain csv tables.
What is a deterministic function?