Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37021 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
how to control the amount of free space in your index pages? : Sql server database administration
What does the on delete cascade option do?
What is clr ddl trigger?
What are the steps you will take to improve the performance of a poor performing query?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
What is data source in connection string?
How to create a user to access a database in ms sql server using "create user" statements?
Explain aggregate functions?
What is the difference between upgrade and migration in sql server?
Define cross join in sql server joins?
Which rendering formats are affected by the pagesize properties?
What are the 3 types of schema?
Is BCNF better than 2NF & 3NF? Why?
What are constraints?
Does any body please help me what question's have asked for SSRS in the interview?
