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 executereader?

950

How to get the definition of a stored procedure back?

977

How you can move data or databases between servers and databases in sql server?

1048

List out what other servers you can use with ssrs?

138

How to create a user to access a database in ms sql server using "create user" statements?

948

What are policy management terms?

981

Do you know what guidelines should be followed to help minimize deadlocks?

970

Can you name some of the dml commands in sql?

1022

What is the purpose of the model database?

1013

How to create new databases with "create database" statements?

1017

What is the maximum size of sql server database?

1002

Tell me what do you understand by a view? What does the with check option clause for a view do?

1019

In what three ways is the return statement used in a stored procedure?

1005

What are the new features in sql server 2016?

967

What kind of problems occurs if we do not implement proper locking strategy?

1400