We help IT Professionals succeed at work.

How to add Foreign key constraint on (1:1) to (0:1) relationship in MS SQL 2005 using T-SQL/GUI?

3,298 Views
Last Modified: 2011-10-19
Hi, Experts,
I am new to MS SQL 2005, attached is a part of my ERD:

I don't know how to add foreign key constraint between tables: Car(1,1) and SalesInvoice (0:1) using T-SQL/GUI, can anyone help?

Also, are there any differences at all with other similar types of foreign key constraints(like, (1:1)  to (1:*) or (1:1) to (0:*)) implementing on MS SQL using T-SQL/GUI.

Thanks,
-Rick
CarDealerShip.gif
Comment
Watch Question

This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
no
what orcic wrote will add a unique constraint
not a foreign key

you can create a unique constraint on the car id column in your table and that will make it unique
but you can't achieve a 1:1 relationship using foreign keys alone

Commented:
of course you need to make foreign key first and then to make it unique (that's what I ment with "You only have to make foreign key to be unique.")

Author

Commented:
Hi, momi_sabag & orcic:

Thanks for your answers, UNIQUE constraint is what I am looking for(which I originally thought it can be done on Foreign key constraint alone somehow).
Based on the question, another question: how to set a constraints on relations like: (1:1) to (1:5)  or  (1:1) to (1:100), which means how to set minimum & maximum number of relationship check?

Many thanks,
-Rick
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.