Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37027 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / ganesh mandlik
DROP :- DROP will Remove Structure as well as all the Data
of the Table.
i.e. Primary Key, Foreign Key, Indexes & etc...
Truncate :- Truncate will Remove only Data But not the
Structure of the Table.
Ganesh Mandlik......
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is reference section?
What are rest-style architecture's?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Where can you find the error log information? : sql server database administration
Can group functions be mixed with non-group selection fields in ms sql server?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
Can you explain about buffer cash and log cache in sql server?
How to throw custom exception in Stored Procedure?
Does partitioning help performance?
Can we do dml on views?
When to use null data driven subscription?
What is a data source file?
How to copy the tables, schema and views from one sql server to another?
What are diverse clauses that form a part of sql?
What is change data capture (cdc) in sql server 2008?
