musalappa@gmail.com
Ten Centuries
Points: 1228
More actions
August 13, 2009 at 3:10 pm
#135325
I need to identify all tables that have a foreign key relationship with a source table column.
sp_help gives constraints information. constraint_keys column has the data REFERENCES source_table (column). Is there any other way to get at this data?
August 13, 2009 at 5:12 pm
#1039053
figured it out.. just have to look at sys.foreign_key_columns catalog view.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply