Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37035 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / vipin narwal
HI TO ALL!!!
DROP: will lead in deleting the structure of the table
along with all associated constraints like Primary
Key,Foreign Key,..etc and also deallocates the memory
allocated to the Database objects..
Truncate: Truncate like Delete deletes the data associated
with a Database Object but structure remains there i.e,
memory remains allocated,...but faster than Delete...
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is partition in sql server?
Can you force a query to use a specific index?
What is logon trigger?
Can we shrink data file in sql server?
What are the new security features added in sql server 2012? : sql server security
What is difference between sql and sql server?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What are the advantages of using stored procedures?
Do you know what is a with(nolock)?
What is the server name for sql management studio?
Explain indexes disadvantages?
What are “lock” hints?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What are the basic functions for master, msdb, model, tempdb databases?
