What is the difference between Drop and Truncate

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / nagireddy.sn

20 Answers
37877 Views
GT Nexus, IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the difference between Drop and Truncate..

Answer / arjun tailor

drop command will delete the entire row also the structure
but truncate will delete the contents only not the
structure.

Is This Answer Correct ?

3 Yes

1 No

What is the difference between Drop and Truncate..

Answer / ferolin j

DROP TABLE- all the relationships with other tables will
no longer be valid, the integrity constraints will be
dropped, grant or access privileges on the table will also
be dropped, if want use the table again it has to be
recreated with the integrity constraints, access privileges
and the relationships with other tables should be
established again.

TRUNCATE TABLE- the table structure remains the same, ONLY
deletes the data.

Is This Answer Correct ?

2 Yes

0 No

What is the difference between Drop and Truncate..

Answer / agnel

* A truncate removes all rows from a tablethat operation
cant be rolled back.
* A drop command removes a table from a database all the
tables rows indexes and privilleges will also be removed.

Is This Answer Correct ?

1 Yes

0 No

What is the difference between Drop and Truncate..

Answer / meera

Drop: delete all data as well as structure.

Truncate: Delete only the data and resets the auto increment
column to 0.

Delete: Delete the selected or all rows from the table , it
doesn't reset to auto increment .

Is This Answer Correct ?

1 Yes

0 No

What is the difference between Drop and Truncate..

Answer / madhu

drop will delete the entier table content including its
structure.
but truncate will delete the datas which in the table.

it wont save the data any where so we cannot rollback those
data.

Is This Answer Correct ?

1 Yes

0 No

What is the difference between Drop and Truncate..

Answer / tamilarasan sivaraj

DROP:It is used to delete the all structure of the db and
also we cant rollback.
EXAMPLE:Drop table student;
It will show error.No table found.

TRUNCATE:It is used to delete the table of the data and
structure remains,we can able to rollback.
EXAMPLE:truncate table student;

No records found;

Is This Answer Correct ?

1 Yes

0 No

What is the difference between Drop and Truncate..

Answer / antim

both are ddl commands.Drop deletes the table with schema
and records but truncate deletes only records.Drop can be
roll back but not truncate.

Is This Answer Correct ?

7 Yes

9 No

What is the difference between Drop and Truncate..

Answer / manisha

Truncate removes data permanently while drop does not,we
can rollback in case of drop.

Triggers does not get fired , in case of truncate ,but in
drop it gets fired.
truncate is much faster than drop

Is This Answer Correct ?

4 Yes

11 No

What is the difference between Drop and Truncate..

Answer / swathi

drop will remove the entire table from the database and can
be rollbacked.

truncate will remove the content of the table and it cannot
be rollbacked.

truncate is little bit faster than drop.

Is This Answer Correct ?

4 Yes

14 No

What is the difference between Drop and Truncate..

Answer / satyanarayana

Drop and Truncate commands both are DML commands.
If we use drop command it will deletes all the table data
as well as tablestructure.But if we use truncate command it
will deletes the table data only.

Is This Answer Correct ?

24 Yes

44 No

Post New Answer