Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25583 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / satyajit patel
DELETE: DML, Manual Commit, Till not committed can be
rollback, can be applied for both row level as well as
table level, can be used in trigger, doesn't release memory.
TRUNCATE: DDL, auto commit, cann't rollback, applied table
level, cann't be used in trigger, releases memory.
In both cases structure remains.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
What are the types of sql commands?
What is full join?
Can we use views in stored procedure?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
How does cross join work?
What is the maximum database size for sql express?
What is the best free sql database?
what is innodb? : Sql dba
What is union?
Is sql dba a good career? : SQL DBA
Is not equal in sql?
What does trigger mean in psychology?
What are different types of triggers?
What is a primary key sql?
Why truncate is used in sql?
