Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 38395 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / swathi
drop will remove the entire table from the database and can
be rollbacked.
truncate will remove the content of the table and it cannot
be rollbacked.
truncate is little bit faster than drop.
| Is This Answer Correct ? | 4 Yes | 14 No |
Post New Answer View All Answers
What is spid in sql server profiler?
How you trouble shoot when any job fails
Explain what is it unwise to create wide clustered index keys?
What is DCL?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
How to enter binary string literals in ms sql server?
What is clustered index
Which is the best place or learning center for MS SQL?????In Bangladesh?????
How to identify current user in ssrs report?
what are acid properties? : Sql server database administration
what is difference between view and Dip.
Write a sql query to sort on different column name according to the parameters passed in the function?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What are the underflow and overflow behaviors on float literals?
Explain can SSRS reports Cache results?
