What is the difference between Drop and Truncate
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
Can group by be used without aggregate functions?
what is datawarehouse?
What is user-defined functions? What are the types of user-defined functions that can be created?
What are rest-style architecture's?
Explain important index characteristics?
What is role playing dimension with two examples? : sql server analysis services, ssas
How to insert and update data into a table with "insert" and "update" statements?
What is a self join in sql server?
How do you set a trace flag in sql server?
List out different types of normalizations in sql server and explain each of them?
What are basics of policy management?
What is user-defined multi-statement table-valued function?
What is the full meaning of dml?
What is the difference between clustered and a non-clustered index?
Define right outer join in sql server joins?