Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between delete,drop and truncate
- 2 Answers
- 6551 Views
- Honeywell, Zomato, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How to find related tables in sql server?
Differentiate between a primary key and a unique key.
Explain about system database?
what is the difference between count(*) and count(1) ?
Define ACID properties in a Database?
System requirements for sql server 2005 express edition?
What is ms sql server triggers?
Explain primary key and foreign key constraints?
What do you understand by mirroring and mention the advantages of the mirroring?
How to change the ownership of a schema in ms sql server?
Explain how dts is used to extract, transform and consolidate data?
Why use “pivot” in sql server?
What does top operator do?
What is transaction server implicit?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
