Apr 4, 2010
What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table.
What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table.
Dropping : (Table structure + Data are deleted), Invalidates the dependent objects ,Drops the indexes
Truncating: (Data alone deleted), Performs an automatic commit, Faster than delete
Delete : (Data alone deleted), Doesn't perform automatic commit
====================
Publicize Yourself... Free!
http://saalram.com
====================
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Saalram.com