relationship

[mo/-/sin]

how to make relationship between two tables in sql server
2005........... ...........

[Philipp Post]

Re: relationship

This is done by the REFERENCES clause.

CREATE TABLE Orders
(order_id INTEGER NOT NULL PRIMARY KEY,
customer_nbr INTEGER NOT NULL
REFERENCES Customers(custo mer_nbr)
ON UPDATE CASCADE,
<further columns here>
)

You could also use the graphical tools in management studio to do
this.

brgds

Philipp Post