can foreign key take role of primary key?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is check constraint in sql server?

517


Do you know what are acid properties?

565


What is the recovery model? List the types of recovery model available in sql server?

486


How to connect Azure federated root database and apply federation in entity framework?

87


What is resource governor in sql server?

542






What is dynamic cursor in SQL SERVER?

559


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1528


What does REVERT do in SQL Server 2005?

551


How to create an index on an existing table in ms sql server?

491


Is sql server free?

518


Is there any difference between primary key and unique with the not null condition?

523


What are the rules to use the rowguidcol property to define a globally unique identifier column?

589


Do you know what is difference between index seek vs. Index scan?

513


How to create a new table in a given schema?

652


How can we delete a table in sql server?

544