Difference
between DROP, DELETE and TRUNCATE
|
Drop
|
Delete
|
Truncate
|
|
1. Whole structure
and data will drop.
2.can’t Rollback
3.can’t use where
clause
4.All data and
structure
drop simultaneously
|
1. Structure will
not drop, data will drop.
2.can Rollback
3.can use WHERE
clause
4. Row by Row data
Delete
|
1. Structure will
not drop data will drop.
2.can’t Rollback
3.can’t use WHERE clause
4. Only all data
will drop, truncate operation drop and recreate the table.
|
No comments:
Post a Comment