what is exact difference between drop and truncate table.

Question Posted / guest

3 Answers
7062 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is exact difference between drop and truncate table...

Answer / sowjanya

Drop Statement deletes the Table structure from the database.
Truncate statement will delete the entire data from Table
and keeps the Table structure as it is in the DB.

Is This Answer Correct ?

13 Yes

0 No

what is exact difference between drop and truncate table...

Answer / samad

ya its correct sowjanya

DROP - delete objects from the database
TRUNCATE - remove all records from a table, including all
spaces allocated for the records are removed in this
rollback is not possible

DELETE - deletes all records from a table, the space for the
records remain rollback is possible

Is This Answer Correct ?

13 Yes

0 No

what is exact difference between drop and truncate table...

Answer / chandana

Drop :
1.Deletes the entire table records as well as the table
structure.
2.It is a DDL Command.
3. Logs are not maintained.
4. Auto Commited.
5.Where clause cannot be used in the Drop statement.Synatx:
Drop table <Table_Name>

Trunctae:
1. Deletes the entire table records ,retains the table
structure.
2. Its a DDL Command.
3. Logs are not maintained. So faster in performace than
Delete.
4. Auto Commited.
Cannot be Rolled Back.
5.Where clause cannot be used with truncate statement.
Truncate Table <Table_Name>;

Delete:

1. Deletes the table records based on condtions ,retains
the table structure.
2. Its a DML Command.
3. Logs are maintained.So slower than trucate.
4. No Auto Commited.So can be Rolled Back.
5.Where clause can be used with truncate statement.
Syantx:
Delete from <Table_Name> where <Condition>;

Is This Answer Correct ?

5 Yes

0 No

Post New Answer