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
- 8930 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
Can sql server be linked with other servers like oracle?
What are the advantages of sql stored procedure?
What is field in algebra?
What is the concept of optimization?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
What is acid mean in sql server?
How to provide login information for a new odbc dsn?
How column data types are determined in a view?
What you can do to delete a table without the delete trigger firing?
What is factless fact table? : sql server analysis services, ssas
What is the meaning of resultset type_scroll_insensitive?
Explain the microsoft sql server delete command? : SQL Server Architecture
How to read data in a table with "select" statements?
What is mean by candidate key?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
