Naheed:

Did you take a look at the information_schema views ?

These views are in the master database which can be used
to see the catalog information about the databases.

You would need something like:

select * from information_schema.table_constraints

select * from information_schema.referential_constraints

John
www.ideo.com

-----Original Message-----
From: Sultana, Naheed [mailto:naheed.[Email Address Removed] November 18, 2002 12:23 PM
To: LazyDBA.com Discussion
Subject: Mapping Index numbers to Specifin FK , PK relationships


Hi List,

I am facing a strange problem, we are moving some tables from SQL to
Teradata , when I try to see the relationships for the tables it is returned
with a index number instead of the name of the relationship like FK , PK etc
,did anyone do something like this before.........can anyone help me where
we can map these numbers to the relationship, do we have a data dictionary
which we can use and will be able to find that out or do we have that kind
of information some where in a table in SQL Server..Pls let me know. Your
help will be deeply appreciated.



TIA
Naheed

MS Sql Server LazyDBA home page