Pages

Monday, November 30, 2009

Truncate Vs Delete

Truncate

Delete

1

It is DDL(Data Definition Language) Statement.

It is DML(Data Manipulation Language) Statement.

2

It Delete all rows from table.

You Can Delete All rows as well as specified rows using Delete.

3

You can not Rollback all raw.

Using Rollback you can retrieve all rows from the point of last commit.

4

It release all raw including Memory space, Just Structure remains there.

It delete all raw but, not Memory space.

5

Example : Truncate Table Emp

Example : Delete From Emp Where Empno=7369

0 comments:

Post a Comment