Microsoft Sql Server Foreign Key Dependencies Show Up Using Sp_msdependencies But Are Not Listed In Sys.foreign_keys

I have a table that when I click view dependencies, it shows less related tables than if I run the following T-SQL EXEC sp_MSdependencies N'Item.Item', null, 1315327 There are t

Solution 1:

Here is what ssms does, when you click on view dependencies: https://www.mssqltips.com/tipimages/1294_sqlcode.txt

The other method, you can use to view dependencies by using INFORMATION_SCHEMA.ROUTINES or syscomments.

Tool which can help you to view dependencies is https://www.red-gate.com/products/sql-development/sql-dependency-tracker/