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
- 8785 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 binary strings be converted into numeric or float data types?
What are ddl (data definition language) statements for tables in ms sql server?
Explain the types of indexes.
What is cursors? And what are the different types of cursor?
Difference between aggregate functions of sql?
What is self contained sub query?
What is the difference between char, varchar and nvarchar?
What are the new data types are introduced in sql 2000?
Explain primary key?
What is difference between aggregate and analytic function?
What is the use of builtinadministrators group in sql server? : sql server security
Does view occupy space?
What is query optimization process?
What is autocommit mode in sql server?
What is data set in report?
