Finding Dependencies Between Database Objects in SQL Server – Andrey Zavadskiy

When I need to analyze dependencies, I should find the answer for 2 questions:

1) which objects does my piece of code depends on? In this case, I get the impact from the others.
When you look at this view definition, you understand that the view depends on two tables.

CREATE VIEW ClientsInfo
AS
SELECT c.ClientName, p.PhoneNumber
FROM Clients c
JOIN PhoneNumbers p ON c.ClientGuid = p.ClientGuid;

CREATE VIEW ClientsInfo

SELECT c.ClientName, p.PhoneNumber

FROM Clients c

JOIN PhoneNumbers p ON c.ClientGuid = p.ClientGuid;

2) which objects does my piece of code influence on? Now I produce the impact to others.

Microsoft SQL Server has some capabilities to analyze dependencies.

catalog view sys.objects

This view shows all database objects and dependencies between parent and child objects such as constraints and triggers. Additional info can be found in MSDN