difference between truncate, delete aur drop?

Answers were Sorted based on User's Feedback



difference between truncate, delete aur drop?..

Answer / v.krishnakumar

in truncate we can delete inside the table data not the
structure of the table,in delete operation we can remove
our data in the table as well as structure but we can get
again using rollback operation, in drop operation it was
permanentely removed from our database we cannot get agian.

Is This Answer Correct ?    13 Yes 2 No

difference between truncate, delete aur drop?..

Answer / aman sharma

truncate are the use to the remove the data as well all the space into the table , and the delete are use to the delete only for the data into the table,and the drop is use to the delete or remove the table....

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What are filegroups in sql server?

0 Answers  


What is data modeling and Reterminal integrity?

0 Answers  


What is dimension table? : sql server analysis services, ssas

0 Answers  


How do I edit a procedure in sql server?

0 Answers  


Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  






How do you check sql server is up and running?

0 Answers  


How ssrs maintain security?

0 Answers  


What is a trace frag?

0 Answers  


Explain foreign key in sql server?

0 Answers  


What command would you use to create an index?

0 Answers  


what is a cursor and what is its use?

2 Answers   L&T,


What is the difference between insensitive and scroll cursor?

0 Answers  


Categories