What is the difference between Drop and Truncate
- 20 Answers
- 34682 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
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
How to check table values in sql server?
What is rtm version in sql server?
What are the 2 types of classifications of constraints in the sql server?
What is the use of =,==,=== operators?
How is foreign key related to primary key?
Explain log shipping?
Which database stores information about replication?
What is autocommit mode in sql server?
What is dirty read?
What are sql server functions?
How to update a field in SQL after ALTERING a row?
What are the three different part of rdl file explain them?
Can sql servers link to other servers like oracle?
Is sql server is free?
