Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 24949 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / p.rajasekar
Delete:
1.It is DML staement.
2.We can rollback the Data
3.We can apply Where condition.
4.Database triggers will fire on DELETE.
5.High water mark Model is not applied
Truncate:
1.It is a DDL statement
2.We cannot rollback
3.We can not apply Where condition
4.Database trigger will not fire
5.High water mark Model is applied
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
what are the limitations of identity column? : Transact sql
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is view explain with example?
what is recursive stored procedure? : Sql dba
Explain aggregate functions are available there in sql?
What is ttitle and btitle?
How is data stored on a disk?
What type of database is sql?
Should I use mbr or gpt?
Can we use commit inside a trigger?
what are integrity rules?
How do I install sql?
What is keys and its types?
What is primary key and foreign key with example?
How to write pl sql program in mysql command prompt?
