What is the difference between Drop and Truncate
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
What are filegroups in sql server?
How to delete the duplicate rows from a table in SQL Server ??
How to access the deleted record of an event?
What are logical/boolean operations in ms sql server?
What are the differences between stored procedure and the dynamic sql?
How to provide values to stored procedure parameters in ms sql server?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What methods do you follow to protect from sql injection attack?
Will the writetext statement activate a trigger?
What are the different types of columns types constraints in the sql server?
What are the advantages of stored procedure in sql server?
Are resultset updatable?