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 the triggers in sql?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
How many tables can be joined in SQL Server?
What does executeupdate return?
What is implicit cursors?
What is the full meaning of dml?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What is code near application topology?
What is the difference between count and distinct count?
Is truncate autocommit?
How to populate a table in sql server?
How to name query output columns in ms sql server?
How to test subquery results with the exists operator?
What is a user-defined function in the sql server and what is its advantage?