DELETE
|
TRUNCATE
|
DROP
|
Removes some or all rows
from a table
|
Removes all rows from a
table.
|
The DROP TABLE command removes one or
more table(s) from the database.
|
A WHERE clause can be used
to only remove some rows. If no WHERE condition is specified, all rows will
be removed.
|
Does not require a WHERE
clause, not allowed here.
|
All related data, indexes,
triggers, constraints, and permission specifications for those tables are
dropped by them operation.
|
It deallocated records
row-by-row in transaction logs and thus is slower than TRUNCATE.
|
It deallocates data pages
instead of rows in transaction logs, thus is faster than DELETE.
|
Some objects like
Views, Stored Procedures that references the dropped table are not dropped
and must be explicitly dropped.
|
This is a DML command as it
is just used to manipulate/modify the table data. It does not change the
property of a table.
|
This is a DDL command as its
resets identity columns, deallocates data pages and empty them for use of
other objects in the database.
|
Thursday, 11 October 2012
DIFFRENCE BETWEEN DELETE, TRUNCATE AND DROP
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment