Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37598 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
What is use of except clause? How does it differ from not in clause?
Can we use max in where clause?
Do you know what is similarity and difference between truncate and delete in sql?
Explain rdbms?
Which sql server table is used to hold the stored procedure script?
What is the purpose of floor function?
What does select 1 mean?
What the different components of Replication and what is their use?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
Can we perform backup restore operation on tempdb?
How to install sql server 2005 express edition?
How adventureworkslt tables are related?
What are different types of replication in sql server?
Explain differences between web edition and business edition?
What is self contained sub query?
