Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between delete,drop and truncate
- 2 Answers
- 6649 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
Mention the differences between substr and charindex in sql server.
How many null values we can have in a unique key field in sql server?
Why is the need for data conversion transformations?
How to use subqueries in the from clause in ms sql server?
What are the differences between DDL, DML and DCL in SQL?
What is update locks?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What are the character string functions supported by sql server 2005?
What are partitioned views?
What is an etl file?
How to drop an existing table?
What is difference between view and materialized view?
What is fill factor and pad index?
What is data source document?
