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 is the status of services on passive node for failover cluster in sql server? : sql server database administration
How to get a list of columns in a view using the "sp_columns" stored procedure?
What the different components of Replication and what is their use?
Explain the properties of sub-query in sql server?
What does <> symbol mean?
What is ms sql server triggers?
Explain why variables called the most powerful component of ssis?
What do you understand by triggers and mention the different types of it?
What are pages and extents? : SQL Server Architecture
Explain what is “asynchronous” communication in sql server service broker?
Which is the main third-party tool used in sql server?
How do you create a data source?
What is the command to change the recovery model?
How adventureworkslt tables are related?
What are the new features are introduced in sql server 2012 reporting services?