Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37613 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
Characterize join and name diverse sorts of joins?
How to achieve Paging of records in SQL SERVER?
How do I partition a table in sql server?
What is index fragmentation in ms sql server?
How can we delete a table in sql server?
What is the optimization being performed in oracle and SQL Server?
What is coalesce in sql server?
What is difference between join and natural join?
Explain about SQLOS?
What is spatial and temporal data?
Why we need sql server?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
what are defaults? : Sql server database administration
What are joins in sql and what are the different types of joins?
How do I open a .db file?
