Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 38392 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 the Ticketing tool used in Wipro technologies at Bangalore...???
What are points to remember while using the fillfactor argument?
What is the use of tempdb? What values does it hold?
What is ms sql server reporting services?
How will you optimize a stored procedure optimization?
do views contain data ?
How to verify a user name with sqlcmd tool?
Explain the truncate command? : SQL Server Architecture
What is the difference between sdf and mdf?
When would you use a before or after trigger?
What is openxml in sql server?
how many no of arguments can be passed in procedures and functions
What is mean by candidate key?
Explain indexed views and partitioned view with their syntax.
How network traffic be reduced by using the stored procedure?
