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
- 8717 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
Define model database?
When is the use of update_statistics command?
Name and describe few console utilities for ssrs?
What is the contrast amongst drop and truncate?
What are the new features of sql server 2008 r2 reporting service?
What is user-defined scalar function?
How do you create a clustered index?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
How many cores do I need for sql server 2016?
What is a unique key constraint?
What is Service Broker in sql server 2012?
How many types of local tables are there in sql server?
What is Extended user-defined?
What is the purpose of optimization?
What is check constraint in sql server?
