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

How can you find out how many rows returned in a cursor?

1003

What are statistics?

982

Explain what is “asynchronous” communication in sql server service broker?

895

What is an execution plan?

1117

Does view occupy space?

919

What is difference between view and materialized view?

925

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

925

What is use of dbcc commands?

1047

How to delete duplicate records based on single column from a table?

1027

What is inner join in sql server joins?

1011

How to provide values to user defined function parameters?

997

What is the correct order of the logical query processing phases?

918

How do you send email on SQL Server?

1037

What languages bi uses to achieve the goal?

987

How to use group functions in the select clause in ms sql server?

1033