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
- 8538 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 is resource governor?
What is reportserver and reportservertempdb ?
Which autogrowth database setting is good?
Write down the syntax and an example for create, rename and delete index?
List some case manipulation functions in sql?
Which tools are available to manage SQL Azure databases and servers?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What do we need queues in sql service broker?
What is the difference between inner join and equi join?
Tell me about pre-defined functions of sql?
Can you edit the .rdl code associated with a linked report?
explain what is raid and what are different types of raid configurations? : Sql server database administration
How can you ensure that the database and sql server based application perform well?
Explain various On-Delete options in a DB table. Which is the default option?
What is after dml trigger?
