Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 38387 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
How to provide column names in insert statements in ms sql server?
can an automatic recovery be initiated by a user? : Sql server administration
Why olap is used?
Explain external key management in sql server 2008
Why would you use sql agent?
Explain logical operators in sql server?
What are locks in sql?
Explain the usage of floor function in sql server.
How can I change procedure name in sql server?
How do users use Report Builder with SQL Server data sources?
How does stuff differ from the replace function?
Explain the use of containers in ssis?
Other than truncate statement, which other command can by-pass the trigger on the tables?
what information is maintained within the msdb database? : Sql server administration
What are the types of subquery?
