difference between truncate and delete ,drop?

Question Posted / jagan_naidu

3 Answers
6147 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

difference between truncate and delete ,drop?..

Drop deletes the table along with its structure from the database.
Delete command deletes the records from the table and it also deletes the table space allocated in the database.

Truncate is similar to Delete but it does not delete the table space from the database.

Drop and Truncate are the DDL command hence can't be rolled back whereas Delete is a DML command and can be rolled back.

Is This Answer Correct ?

13 Yes

2 No

difference between truncate and delete ,drop?..

Answer / surendra

truncate

it deletes only the records from the table
it doesn't delete the structure of the table
we cannot rollback it
we cannot delete a particular record from the table
it is ddl

drop

it deletes the records as well as structure of the table too
we cannot rollback the records
we can flashback the table from the version 9x
it is ddl

delete

it deletes the only records which are we mention in the where clause or whole records
it is dml
we can rollback it

Is This Answer Correct ?

3 Yes

2 No

difference between truncate and delete ,drop?..

Answer / sachin

the main difference between delete and truncate is that in
the truncate u will delete all the values from the table as
well as from the data dictionaries also while delete is used
to delete selected values and in the same way drop is use
to delete whole data from a table but the deleted data will
occupy the memory space in the extents but if we perform
truncate then the extents are free from the deleted data .....

Is This Answer Correct ?

0 Yes

0 No

Post New Answer