no,foreign key is possible for null value in column. this rules not matchi

can foreign key take role of primary key?

Question Posted / radhakrishnan vaithilingam

Answer Posted / radhakrishnan vaithilingam

no,foreign key is possible for null value in column.
this rules not matching with PK.

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1067

What is the difference between update lock and exclusive lock?

913

What is a cube? : sql server analysis services, ssas

944

Explain some stored procedure creating best practices or guidelines?

869

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1095

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

954

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

838

How to get the definition of a view out of the sql server?

938

How can windows applications connect to sql servers via odbc?

1059

Write an SQL query to obtain the 2nd highest salary.

1018

What is partition in sql server?

972

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

992

How to find the source of a table in sql server?

920

Which trace flags are enabled in sql server?

939