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

How to find index size for each index on table?

0 Answers  


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

0 Answers  


What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  


What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,


Write an sql query to find first weekday of the month?

0 Answers  


How to use column default values in insert statements in ms sql server?

0 Answers  


How to choose all records from the table?

0 Answers  


Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  


What is the use of sql profiler in sql server 2012?

0 Answers  


How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

0 Answers  


Can a unique index be created on a column, which contains null?

0 Answers  


How can sql server instances be hidden?

0 Answers  


Categories