Finding dependencies of a table in sql server
Many a times we face the problem of finding the foreign key relationships, triggers and stored procedures that are referring to a particular table. The below query will help you in identifying the following things: Find the entire hierarchy of all the parent tables and the corresponding parent table column names and their respective child(s). […]