What is difference between TRUNCATE & DELETE?
- 16 Answers
- 39566 Views
- Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / rampratap singh
Truncate is DDL so it does not create rollback segments,
where as DELETE is DML and creates rollback segments.
Truncate removes/reset the high watermark.
Delete does not do that.
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
Show the two pl/sql cursor exceptions.
What is the use of count (*) in sql?
What is database migration?
Explain select statements in sql?
How to combine two stored procedures in sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
Can a primary key be a foreign key?
explain the delete statements in sql
Explain about various levels of constraint.
what is recursive stored procedure? : Sql dba
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What are the string functions in sql?
Which is better trigger or stored procedure?
Are stored procedures faster than dynamic sql?
What is a field in a database?
