How to get a list of MSSQL dependent tables using a query?

Question

Database

Good afternoon. I collect several bases together, I struggle with the problem of duplicate keys. I'm trying to automate the process. I threw a program that changes keys and makes changes to dependent tables. At the moment, you have to manually enter the name of each table, etc., which is not convenient.
I would like to enter a query with the name of the table and get a list of tables that refer to it, something like "View Dependencies" in Management Studio, is this real? Google led me to a dead end, knowledge is not enough.

Answer 1

In principle, everything is in sysobjects and the studio extracts exactly from there
query structures are somewhat multi-level, it works
p / s / by delirium: sql profiler intercept the studio query to search for dependencies)