what is the difference between delete,drop and truncate
Answers were Sorted based on User's Feedback
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 |
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 |
What is query optimization process?
State the difference between local and global temporary tables?
How do I start sql server 2017?
What are page splits? : SQL Server Architecture
How to write a script for upate the data in prod , i have 50000 row are there
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What do you mean by an execution plan? Why is it used? How would you view it?
What is difference between equi join and natural join?
I have to display ten columns values from diffrent ten tables. how many joins are require?
10 Answers CarrizalSoft Technologies, HCL,
What are the advantages of log shipping?
Can you explain full-text query in sql server?
what are the new features introduced in sql server 2000? : Sql server database administration