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 |
Monday, November 30, 2009
Truncate Vs Delete
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment