Truncate will fail if the concerned table has foreign key constraints whi

Can you tell me the difference between DELETE & TRUNCATE
commands?

Question Posted / kumar

Answer Posted / kumar

Truncate will fail if the concerned table has foreign key
constraints while delete doesnt.

Is This Answer Correct ?

15 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What is the size of transaction log file?

873

What is default port number for sql server 2000?

1001

What is the difference between NOROW and LOCKROW?

2785

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1011

How do I save a stored procedure in sql server?

944

What are the grouping functions?

893

How you can get the list of largest tables in a database?

949

What is the full meaning of dml?

912

Will the writetext statement activate a trigger?

1024

What is a livelock?

920

What are tables in sql server?

970

What are different replication agents and what's their purpose? : sql server replication

962

What Are the Main Features of SQL Azure?

115

what are the Prerequisites for Replication?

11253

what are the types of indexes? : Sql server database administration

1068