<b> Foreign Keys Using Enterprise Manager </b>

[jfield817]

Using SQL 7 ...

Where on Enterprise Manager can I see the
Foreign Keys on a Table ....
"All Tasks" shows indexes and triggers
but not Foreign Keys

I know how to do it using system stored procs, however ....

Thanks
John

 

[tlbroadbent]

Enterprise manager:

1) Open a table in design mode
2) Open the table properties
3) Slect the Relationships tab

Alternate:

1) Open or create a Database diagram
2) You can view and create foreign keys in the diagram Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[jfield817]

I had Found it after poking around
Thanks
John