<div>
This is almost impossible... Of course, simple stored procedure containing one query, e.g.<br><pre><code class="code-1 nolinks" id="code-20-43329065-1"><span>SELECT * FROM dbo.users</span>
</code></pre>is easy to convert into Visio but that's not ordinary case obviously.<br>What you can do is to collect SP parameters in all cases, output data structure in some cases, maybe local variables declared and tables/views <u>possibly</u> accessed, and also you can obtain a list of syntax errors but that's almost everything... No tool can tell what was the intention of the developer, what the code should do etc. <br><br>In other words the information requested by you should be available prior to SP coding...<br><br>Each SP should contain some standard comment which provides the info requested for your purposes and which can then be used to generate some technical documentation..<br><br>
</div>


Director of IT

Richard Comito

<div>
This was posted in the SQL Topic Area. &nbsp;That doesn't specify any database product or version.<br />
<br />
Assuming SQL Server.<br />
<br />
I don't know of any tool that will give you what you want. &nbsp;Most database products have a way to view object dependency.<br />
<br />
I found this for SQL Server:<br />
<a href="https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/view-the-dependencies-of-a-stored-procedure?view=sql-server-ver15" rel="ugc">https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/view-the-dependencies-of-a-stored-procedure?view=sql-server-ver15</a><br />
<br />
These types of things aren't 100%. &nbsp;If the code uses dynamic SQL then they might not show up in the system views as a dependency but it is a place to start.
</div>


<div>
<div class="content wysiwyg-content fr-view">
I am working with a DB that has a lot of custom SP and I wanted to know if there is a tool out there that can help me with visualizing the SP.<br><br>I have both Visio and Lucidchart but from what I can see neither can take a stored procedure and turn it into a flowchart and identify all the tables and procedures the SP is calling.<br><br>Thank you,<br><br>Rich
</div>
</div>



I am working with a DB that has a lot of custom SP and I wanted to know if there is a tool out there that can help me with visualizing the SP.
I have both Visio and Lucidchart but from what I can see neither can take a stored procedure and turn it into a flowchart and identify all the tables and procedures the SP is calling.
Thank you,
Rich

Tool to visualize SQL Procedures

Visio is a diagramming and vector graphics application that is part of the Microsoft Office family that allows the user to create diagrams for organizational and planning purposes. The Premium edition has additional templates for more advanced diagrams and layouts, as well as capabilities intended to make it easy for users to connect their diagrams to data sources and to display their data graphically, as well as intelligent rules, validation, subprocess (diagram breakdown). one-step connectivity with Excel data, information rights management (IRM) protection for Visio files, modernized shapes for office layout, detailed shapes for site and floor plans, modern shapes for home plans, and IEEE compliant shapes for electrical diagrams.

Microsoft Visio

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.