data dictionary questions

[fixthebug2003]

HI,
In SQL Server
1. What data Dictionary tables should I look into to see the dependencies of one table over the other..!

2. Where are the Foreign key constraint Names ..like FK_table1_deptno (defined ny user during creation of Table)
stored?

Thanks
Fixthebug2003

 

[JohnDTampaBay]

I would use

sp_depends

to determine dependencies. The SysDepends table tracks dependencies, but Microsoft keeps threatening to change the table structures on us. They assure us the system procedures and Information_Schema views will not change. Yeah. Check out

sp_fkeys

and

sp_foreignkeys

in BOL for foreign key information.

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.