Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

difference between truncate, delete aur drop?

Question Posted / ajayjuyal87

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 is the sql equivaent of the dataset relation object ?

0 Answers  

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

0 Answers  

what is mean by constraints in sql?

5 Answers   Granada, IBM,

How to get number of days in a given year?

4 Answers   ADP,

How can I check that whether automatic statistic update is enabled or not?

0 Answers  

What are the pros and cons of creating extended stored procedures?

1 Answers  

Explain triggers?

0 Answers  

How many types of stored procedures are there in sql server?

0 Answers  

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

What are the types of subquery?

0 Answers  

can foreign key take role of primary key?

5 Answers   CarrizalSoft Technologies, TCS, Villa Marie,

Can you explain what are commit and rollback in sql?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories