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
How do you size a resultset?
Tell me extended events in sql server 2008?
What is 1nf 2nf and 3nf?
Explain Geography datatype in SQL Server
What are three major types of constraints?
How to see the event list of an existing trigger using sys.trigger_events?
What is multilevel indexing?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is the sql server agent?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What is relationship? What number of sorts of relationship are there?
Can you pass expressions to function parameters?
Define indexes?
what is denormalization? : Sql server database administration
What are sql dirty pages?