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

Explain syntax for viewing trigger?

924

how to use DTS package in 2000,2005,2008 in sql server

1838

how can u get last observation in an unknown dataset ?

2436

What is Federation Root Database?

104

What is the full form of ddl?

925

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

950

How do I setup a local sql server database?

1006

If no size is defined while creating the database, what size will the database have?

988

Can I use sql azure as a backup with log shipping or database mirroring?

156

What is the exact numeric data type in sql?

1002

What is self contained sub query?

1054

Explain how you can deploy an SSRS report?

150

What is a cache in ssrs?

134

What is BCP? When does it used in sql server 2012?

1061

What is the difference between inner join and equi join?

997