Difference Between DELETE & TRUNCATE Are
1. DELETE is a DML Command & TRUNCATE is a DDL Command
2. After DELETE can rollback the Records & After TRUNATE cannot rollback the records
3. In DELETE Command you can give the conditions in WHERE Clause & In TRUNCATE you cannot give conditions
4. After using DELETE Command The memory will be occupied till the user does not give ROLLBACK or COMMIT & After using TRUNCATE Command The memory realeased immediately
Have a nice day... 'N happy Coding :)
No comments:
Post a Comment