We can create 3 tables with PK and FK but can not insert rows. Try it.

Assume,there are three tables in a database, Can i have
both primary key and foreign key for each table in the same
database?

Question Posted / madhu

Answer Posted / madhu

We can create 3 tables with PK and FK but can not insert
rows. Try it.

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does <> symbol mean?

949

What does the on update no action do?

1001

What is a join in sql?

1069

Define Joins?

1010

What is role playing dimension with two examples? : sql server analysis services, ssas

982

Can one drop a column from a table?

1001

What do we have to check in database testing?

995

Give main differences between "Truncate" and "Delete".

1074

What is unique key constraint?

1029

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

953

What is coalesce in sql server?

1037

How to transfer a table from one schema to another?

983

How to handle error or exception in sql?

969

How is table type constraint applied to a table?

961

What are pages and extents? : SQL Server Architecture

1002