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


Please Help Members By Posting Answers For Below Questions

Can group by be used without aggregate functions?

707


what is datawarehouse?

877


What is user-defined functions? What are the types of user-defined functions that can be created?

817


What are rest-style architecture's?

165


Explain important index characteristics?

797


What is role playing dimension with two examples? : sql server analysis services, ssas

814


How to insert and update data into a table with "insert" and "update" statements?

746


What is a self join in sql server?

817


How do you set a trace flag in sql server?

805


List out different types of normalizations in sql server and explain each of them?

748


What are basics of policy management?

871


What is user-defined multi-statement table-valued function?

863


What is the full meaning of dml?

753


What is the difference between clustered and a non-clustered index?

804


Define right outer join in sql server joins?

778