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

Answer Posted / siva

Hi,

You can place the foreign key column in each table to allow
nulls. And insert values.

But I am still worried a lot about deletion of the values
from these tables ?

Plz post your comments

Regards,
Subbu

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to defragment table indexes?

550


Why transaction is important?

565


why would you use sql agent? : Sql server database administration

527


What is a non-clustered index?

563


What is the Difference Between Primary and Foreign Key?

587






What is conditional split?

543


How can windows applications connect to sql servers via odbc?

585


What does executeupdate return?

539


What is raid and what are different types of raid levels?

592


Find first and last day of current month in sql server

597


What were the latest updates to SQL Azure service?

94


What is a fan-out query in SQL Azure?

99


How to include date and time values in sql statements?

630


What is star, snowflake and star flake schema? : sql server analysis services, ssas

659


Explain linked server in sql?

696