Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37875 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 log shipping? Can we do logshipping with SQL Server 7.0 ?
Tell me what are the essential components of sql server service broker?
What is the difference between a function and a trigger?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What are the components of dbms?
Explain the advantages of merge replication?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is the difference between the application object and session object?
what are the reporting service components in SSRS?
Explain about analysis services?
Is null in sql server?
What is a ddl statement?
What is the benefit of normalization?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What is attribute? : sql server analysis services, ssas
