Interested to Buy Any Domain ? << Click Here >> for more details...
Assume,there are three tables in a database, Can i have
both primary key and foreign key for each table in the same
database?
- 4 Answers
- 8684 Views
- I also Faced
- E-Mail Answers
Answer Posted / subbu
Yes we can have that ! Let me expalin with this small
example.
(PK)ProjectID (FK)ClientID -- Project Table
(PK)ClientID (FK)ProjectManagerID -- ClientTable
(PK)Employee (FK)ProjetcID -- Employee Table
Check This In this example I am having 3 tables and each
table have PK and FK.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What are the grouping functions?
How you provide security to cube? : sql server analysis services, ssas
what changed between the previous version of sql server and the current version? : Sql server database administration
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What is a view and what are its advantages?
What is dirty read?
how many layers of tcp/ip protocol combined of? : Sql server database administration
How is table type constraint applied to a table?
how you can configure a running aggregate in SSRS?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What are the limitations in ssrs on sql server express edition?
What is the difference between indexing and hashing?
How to generate create procedure script on an existing stored procedure?
How column data types are determined in a view?
What are the advantages of mirroring?
