Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37283 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / mayur jain
Drop means removing.Removing the existence.
Truncate - there is no log maintained for the deleted
records.As when we perform delete a log is maintained a slow
process.
| Is This Answer Correct ? | 27 Yes | 13 No |
Post New Answer View All Answers
How to delete duplicate records based on single column from a table?
Why we need sql server?
How to create sub reports?
How does a profiler work?
How many triggers you can have on a table?
What are policy management terms?
Distinguish between commit and rollback?
Explain table valued parameters in sql server? Why tvp used?
What is difference between sql and sql server?
What are a scheduled jobs?
What is a db view?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
Explain can you implement data mining in ssrs?
Define self join in sql server joins?
How do I know if localdb is running?
