what is the difference between delete,drop and truncate

Answers were Sorted based on User's Feedback



what is the difference between delete,drop and truncate..

Answer / mohammadali.info

*The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation you need to
COMMIT or ROLLBACK the transaction to make the change permanent or to undo it.

*TRUNCATE removes all rows from a table. The operation cannot be rolled back. As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.

*The DROP command removes a table from the database. All the tables' rows,
indexes and privileges will also be removed. The operation cannot be rolled back.

*DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. Therefore DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.

IF Answer is Correct Pls give Rate

Is This Answer Correct ?    46 Yes 0 No

what is the difference between delete,drop and truncate..

Answer / krishna

DELETE,DROP,TRUNCTATE are to use the remove the rows from the table

DELETE: Delete is used to delete the rows from table by using where condition also and we can ROLLBACK it also

DROP: Delete rows permanently and we can not ROLLBACK it.

TRUNCATE : Delete the data not the structure means in this delete only data but structure is same

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is a functions and types in sql server?

0 Answers  


You want to implement the one-to-one relationship while designing tables. How would you do it?

0 Answers  


Do you know what is lock escalation?

0 Answers  


What is the maximum size of sql server database?

0 Answers  


Tell me the difference between clustered and non-clustered index?

0 Answers  






What is dataset and its uses

2 Answers  


what is DTS what are tasks available

1 Answers   Wipro,


Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,


What is the usage of the sign function?

0 Answers  


explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  


What are the characteristics of modern DBMS?

0 Answers   Ericsson,


Explain cdc and sql injection?

0 Answers  


Categories