Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37883 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / manisha
Truncate removes data permanently while drop does not,we
can rollback in case of drop.
Triggers does not get fired , in case of truncate ,but in
drop it gets fired.
truncate is much faster than drop
| Is This Answer Correct ? | 4 Yes | 11 No |
Post New Answer View All Answers
Which rendering formats are affected by the pagesize properties?
What are ddl triggers and types of ddl trigger?
What will be the maximum number of index per table?
When cursors are useful?
How to make a column nullable?
What is subreport?
Why use “nolock” in sql server?
What is an example of a primary key?
Define cross join in sql server joins?
What is difference in performance between insert top (n) into table and using top with insert?
What is a ddl statement?
What are advantages of ssrs or why we should use ssrs?
What do you do in data exploration
What is cursors? And what are the different types of cursor?
How self join is different from outer join?
