Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between delete,drop and truncate
- 2 Answers
- 6651 Views
- Honeywell, Zomato, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is store procedure? When do you use?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
what is hash nonclustered index
Explain SSRS Architecture?
Define left outer join?
How to verify a user name with sqlcmd tool?
What is de-normalization and what are some of the examples of it?
What are translations and its use? : sql server analysis services, ssas
Differentiate between ms sql server reporting services vs crystal reports?
What are cascading parameters in ssrs reports?
Which are new data types introduced in sql server 2008?
Explain the properties of sub-query in sql server?
How to turn off warning messages during php execution?
What extended events?
What is inner join in sql server joins?
