can foreign key take role of primary key?
Answer Posted / @panwar
yes but for same table and if you use foriegn key as a
primary key for same table then there will be no benifit of
master-detail concept for it relation.
and if you follow the Master_detail concept then you can't
use as primary key for another table.
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What are data files?
‘Order by’ is not allowed in a view how can you sort information from a view?
List out different types of normalizations in sql server and explain each of them?
what are different types of backups available in sql server? : Sql server database administration
What is the use of @@spid?
what changed between the previous version of sql server and the current version? : Sql server database administration
What is the significance of null value and why should we avoid permitting null values?
Explain what is lock escalation?
Can we call future method from trigger?
How to install sql server 2005 express edition?
What are the advantages of using third-party tools?
What are cursors in ms sql server?
What is the difference between DATETIME2 and DATETIME?
What do you understand by user-defined function in the sql server?
Can binary strings be used in arithmetical operations?