Listink Foreign Key Linkings

[mutley1]

Hi All,

SQL 2000.

We are looking to redesign a bit od a bodge job of an old database which has about 700 od tables in it, and my question is such. Is there an easy way to list tables, PK's FK's (that's the easy bit which I can do), but id the FK is linked to ANOther table, to show that linking as well (i.e. under relationships tab of table design / manage keys).

Cheers,

M.

 

[Mich]

I think this is what you're looking for. Not the most optimized query, but it gets the job done.

select name as ForeignKey, 
(select name from sys.objects o where fk.parent_object_id=o.object_id) as ParentTable,
(select name from sys.objects o where fk.referenced_object_id=o.object_id) as ReferencedTable
 from sys.foreign_keys fk
order by name asc

-If it ain't broke, break it and make it better.

 

[Mich]

Oops, just saw that you're looking at SQL 2000. My query is for 2005.

-If it ain't broke, break it and make it better.

 

[mutley1]

No worries Mich, thanks for reading the post though!

Appreciated,

M.