I will query on the system catalogs but know that so far everything Iv'e found either works only for non-table objects (i,.e. Views, Stored Procedures, UDF's) or does not work for all Parent/Child relationships which has me dumb founded.
For example I've tried both sys.sql_expression_dependencies and sql_expression_dependencies and while both show dependencies they are only for non-table objects such as views and Stored Procedures which is find weird because the description for these says ALL dependencies. Perhaps tables are not dependencies even when one is a child table.
I've also Tried sp_fkeys to get a list of all FK's for the specified table and while it shows most of the Foreign keys it does not list them all. All objects in my DB are of the same default schema DBO. Just mentioning that in case it matters.
NOTE: I can get the View Dependencies in SSMS to work for most parent/child tables but not all even though all are using Primary/Foreign keys. Needless to say this has left me very confused.
Kindest Regards,Just say No to Facebook!