What is the difference between Drop and Truncate

Answers were Sorted based on User's Feedback



What is the difference between Drop and Truncate..

Answer / pavan

Drop will delete all the existing structure. if it applies
to a table, Truncate will delete only the data while
keeping the structure of the table as it is.

Is This Answer Correct ?    72 Yes 3 No

What is the difference between Drop and Truncate..

Answer / koti-khammam

TRUNCATE: Only data is deleted structure of the table
exists.


DROP: Both data and structure of the table gets removed.

Is This Answer Correct ?    57 Yes 1 No

What is the difference between Drop and Truncate..

Answer / mohsin mohammed abdul

Drop means removing the existing object from the database.
turncate means you are deleting the data from the table and
oracle implicitly issues commit statment and even when you
say rollback , you won't get the data back due to commit ..

Is This Answer Correct ?    36 Yes 12 No

What is the difference between Drop and Truncate..

Answer / lakshmi

Drop can be used to drop the entire table including data
and structure of table where as truncate removes rows from
table but the structure of table remains as it is.

Is This Answer Correct ?    18 Yes 1 No

What is the difference between Drop and Truncate..

Answer / mayur jain

Drop means removing.Removing the existence.

Truncate - there is no log maintained for the deleted
records.As when we perform delete a log is maintained a slow
process.

Is This Answer Correct ?    27 Yes 13 No

What is the difference between Drop and Truncate..

Answer / suman kalyan betal

DROP means it's drop the table(with rows,Pk_key, Fk_key and
indexces)from the database.
TRUNCATE do the same as DROP but maintain the Pk_key,
Fk_key and indexces declaration only remove rows.

---by suman kalyan betal (suman_kal@rediffmail.com)

Is This Answer Correct ?    9 Yes 3 No

What is the difference between Drop and Truncate..

Answer / ganesh mandlik

DROP :- DROP will Remove Structure as well as all the Data
of the Table.
i.e. Primary Key, Foreign Key, Indexes & etc...

Truncate :- Truncate will Remove only Data But not the
Structure of the Table.


Ganesh Mandlik......

Is This Answer Correct ?    4 Yes 0 No

What is the difference between Drop and Truncate..

Answer / vishant kakwani

drop is delete the data with table and if id is used as autoincrement then id can't be started with 1.
Truncate is delete the only data table as it is and autoincrement id will started with 1 every time if you truncate the table.

Is This Answer Correct ?    4 Yes 0 No

What is the difference between Drop and Truncate..

Answer / sripathi venkata ramesh

I am Sripathi Venkata Ramesh

Drop: Table structure + Data are deleted

Truncate: Data alone deleted but it is faster than delete.
Here we can not use where Condition here.

Delete: Data alone deleted. Here we can use where condition
here

Is This Answer Correct ?    3 Yes 0 No

What is the difference between Drop and Truncate..

Answer / vipin narwal

HI TO ALL!!!


DROP: will lead in deleting the structure of the table
along with all associated constraints like Primary
Key,Foreign Key,..etc and also deallocates the memory
allocated to the Database objects..

Truncate: Truncate like Delete deletes the data associated
with a Database Object but structure remains there i.e,
memory remains allocated,...but faster than Delete...

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

0 Answers  


What is rtm version in sql server?

0 Answers  


How do I run sql server 2014?

0 Answers  


What are subquery and its properties?

0 Answers  


How you trouble shoot when any job fails

0 Answers  


What do you understand by physical_only option in dbcc checkdb?

0 Answers  


what is Equity join?

2 Answers   ADP,


Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  


How many primary keys are possible in a table?

0 Answers  


What is bcnf normalization form?

0 Answers  


What are the acid properties?

0 Answers  


What is a system database and what is a user database?

0 Answers  


Categories