Cacase can be used to delete a table which is referenced by FOREIGN KEY

Can we use Truncate command on a table which is referenced
by FOREIGN KEY?

Question Posted / samji

Answer Posted / samji

Cacase can be used to delete a table which is referenced
by FOREIGN KEY

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain datetime2 data type in sal server 2008?

856

Mention the differences between substr and charindex in sql server.

982

What are points to remember while using the fillfactor argument?

904

Tell me the use of keyword with encryption. Create a store procedure with encryption?

958

In what version of sql server were synonyms released?

903

What do you mean by an execution plan?

1050

Explain transaction server consistency?

915

How do I completely remove sql server instance?

1020

What is a view and what are its advantages?

1052

What is the default sql server instance name?

968

Tell me what is de-normalization and what are some of the examples of it?

958

What does set rowcount do?

865

What is the name of the Database which IBM mainframe uses?

945

Does table partitioning improve performance?

899

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

952