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
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
How to find table changes in sql server?
can you implement data mining in SSRS?
What is use of dbcc commands?
What are xml indexes?
How to create “dependant” parameter “make, model, year”
How can you find out which stored procedures are recompiling?
Explain the properties of the relational tables?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What is logshipping and its purpose?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Can two tables have the same primary key?
Does partitioning improve performance?
What is efficiency data?
What is normalization? Describe its different types.