Impact Analysis Diagrams for SQL Server


Impact analysis diagrams show the references to an item (table, column, object, method, variable, etc.) for SQL Server database T-SQL code.

Unlike Call Graphs that are multi-levels, Impact Analysis diagrams are single-level. But they show more details about the structure of the T-SQL code and the container(s) of the objects referencing the initial item.

Impact analysis diagrams are very useful to:

  • Evaluate the consequences of a change.
  • Identify the pieces of code that should be modified to accomplish a given change.

How to Generate Impact Analysis Diagram for SQL Server Database T-SQL Code ?

  • In the treeview, select an item to show all its references.
    • For instance, select a table, column, object, function or a variable.
    • Go to [Diagrams] in the ribbon menu, and click on "Impact Analysis"
    • A dependency diagram is generated in the treeview:

generate impact analysis diagrams from SQL Server (T-SQL) code

  • Select an object in the diagram to view its code in the source code view

view impact analysis diagrams for SQL Server object

Edit a diagram

   Read this article to edit and save a diagram

Share, Export, Print a diagram

   Read this article to share, export, and print a diagram


Visual Expert, SQL Server, Transact-SQL, Impact Analysis, Code Diagrams