I've very new to SQL Server and the Enterprise Manager. Can anyone
point me to how to set up the relationships between the tables, and
denoting which are the foreign keys?

I'm coming from an Access 2k background, it that makes a difference.

Regards,

Shay B.

On Nov 19, 2:48*pm, Shay <shay.bucha... (AT) gmail (DOT) com> wrote:
It might help to note that I'm in SQL Server 7.0

Shay B.

Shay , shalom

You can use Enterprise Manager (diagram) folder to set relationship between
tables or write a script in query analiyzer

"Shay" <shay.buchanan (AT) gmail (DOT) com> wrote

On Nov 19, 2:48 pm, Shay <shay.bucha... (AT) gmail (DOT) com> wrote:
It might help to note that I'm in SQL Server 7.0

Shay B.

To do that graphically, you must create one or more a DIAGRAM. Insert the
tables that you want on the Diagram and you can then etablish your
relationships graphically. When inserting one or more tables onto the
Diagram, the EM should show you the existing relationships that has been
created using scripts.

Learning how to do that with a script (that you could run in the Query
Analyser for example) would also be a good idea.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)


"Shay" <shay.buchanan (AT) gmail (DOT) com> wrote