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.

Answer / koti-khammam

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


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

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 ..

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.

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.

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)

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......

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.

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

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...

1 01 101 01010

0 Answers  

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

1 Answers   Covansys,

which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,

Can we shrink data file in sql server?

0 Answers  

What is Stored Procedure? What is Views in sql server? Difference between a User Defined Function and a Stored Procedure Difference between a primary key and a unique key? What is a join and explain different types of joins. Difference between temp table and table variable Difference between Triggers and Stored Procedures Difference between UNION ALL Statement and UNION What is COALESCE / Why do we use COALESCE? Why we use SET ROWCOUNT in Sql How many clustered index can have a table How many types of local tables in SQL SERVER Difference between DELETE and TRUNCATE What is Aggregate Functions? What is Row_Number()? What are Ranking Functions? What is NOLOCK? What is CTE? What are the Advantages of using CTE? What is the STUFF function and how does it differ from the REPLACE function? What are the difference between clustered and a non-clustered index? What are the different index configurations a table can have? Difference between a HAVING CLAUSE and a WHERE CLAUSE? Difference between SET and SELECT Provide all the built in string function of SQL SERVER Difference between char and varchar data types Define candidate key, alternate key, composite key. What are constraints? Explain different types of constraints. What is a self join? Explain it with an example. How will you convert table row to a column comma separated value

4 Answers   ACS,

How do you simulate a deadlock for testing purposes

1 Answers  

sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  

What is default port number for sql server 2000?

0 Answers  

how to avoid cursors? : Sql server database administration

0 Answers  

What is inline variable assignment?

0 Answers  

What is dbcc? Give few examples.

0 Answers  

How to truncate the log in sql server 2012? : sql server database administration

0 Answers