difference between truncate, delete aur drop?

Question Posted / ajayjuyal87

2 Answers
5345 Views
I also Faced
E-Mail Answers

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

Explain the dbcc pintable command when would you use it?

0 Answers

What does Master database contains?

0 Answers Abacus,

What is Stored Procedure? What is Views in sql server? Difference between a User Defined Function and a Stored Procedure Difference between a primary key and a unique key? What is a join and explain different types of joins. Difference between temp table and table variable Difference between Triggers and Stored Procedures Difference between UNION ALL Statement and UNION What is COALESCE / Why do we use COALESCE? Why we use SET ROWCOUNT in Sql How many clustered index can have a table How many types of local tables in SQL SERVER Difference between DELETE and TRUNCATE What is Aggregate Functions? What is Row_Number()? What are Ranking Functions? What is NOLOCK? What is CTE? What are the Advantages of using CTE? What is the STUFF function and how does it differ from the REPLACE function? What are the difference between clustered and a non-clustered index? What are the different index configurations a table can have? Difference between a HAVING CLAUSE and a WHERE CLAUSE? Difference between SET and SELECT Provide all the built in string function of SQL SERVER Difference between char and varchar data types Define candidate key, alternate key, composite key. What are constraints? Explain different types of constraints. What is a self join? Explain it with an example. How will you convert table row to a column comma separated value

4 Answers ACS,

What is dml command?

0 Answers

How do I start and stop sql server?

0 Answers

Is null in sql server?

0 Answers

Which institute is best for SQL Server 2005 Training?

6 Answers

If we delete pack Spec what will be the status of pack Body ?

0 Answers Nagarro,

What is openrowset sql server?