What is the difference between Drop and Truncate
- 20 Answers
- 34046 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 add additional conditions in SQL?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
How do I create a stored procedure in dbml?
Explain the functionalities that views support?
What is a mutating table error and how can you get around it?
Do you know the cursor optimization tips?
Why use “in” clause in sql server?
How to send email from database?
Is null in sql server?
How can you manage sql azure security?
what happens on checkpoint? : Sql server database administration
What are constraints in microsoft sql server?
How to create an index on a view?
What is a cube? : sql server analysis services, ssas
Explain cross join or cartesian product in sql?
