Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37882 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
When would you use sql joins?
What are difference between Cluster index and Non-Cluster index?
What is use of except clause? How it differs from not in clause?
Define inner join? Explain with an example?
How do I find information about the install locations for the various instances running on a computer?
What is buffer cash in sql server?
Can we write a distributed query and get some data which is located on other server and oracle database?
How to use order by with union operators in ms sql server?
Explain what is scheduled job and how to create it?
what is the primary use of the model database? : Sql server administration
What are the differences between substr and charindex in sql server.
Explain the dirty pages?
What are commonly used mssql functions in php?
What is the difference between a view and a stored procedure?
Some queries related to SQL
