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
- 8941 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
How to replace given values with null using nullif()?
Tell me what do we need queues in sql service broker?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What do you mean by subquery?
What happens if null values are involved in comparison operations?
Do you know what is blocking?
What do you think of this implementation? Can this be implemented better?
how would you troubleshoot blocking? : Sql server database administration
How do you migrate data from mssql server to azure?
What is database replication? What are the different types of replication you can set up in sql server?
What is the security principal at the database level that represents your session?
Explain what is use of dbcc commands?
Define self join?
How can I check that whether automatic statistic update is enabled or not?
What is the difference between dropping a database and taking a database offline?
