We can use the sp_fkeys system stored procedure to find all foreign keys which point to a particular table. The following T-SQL command will return a list of all tables which are referencing the primary key of the Products table:

EXEC sp_fkeys Products

The sp_fkeys system stored procedure comes very handy when dealing with large databases which have hundreds of tables.

Cheers,
Raj

~~~ CODING FOR ETERNITY !!! ~~~