Stored Procedure Insights
DB Insights automatically analyzes stored procedures, summarizing their logic, identifying table and view usage, and uncovering any hidden relationships.
Key Capabilities
Purpose & Functionality
AI-generated insights into the business logic and purpose of each stored procedure for clearer understanding.
Joins & Tables
Identifies which tables and joins are used in the T-SQL code.
Sorting & Filtering Conditions
Highlights WHERE, ORDER BY, and other clauses for quick reference.
Implicit Relationship Identification
Pinpoints cross-table interactions revealed in the T-SQL script.
T-SQL Code Display
Presents the actual T-SQL in a separate tab for in-depth review.
List of Procedures
The DB Insights portal lists all available Stored procedures in the database, accompanied by comprehensive descriptions. This feature helps you understand each stored procedure’s purpose and functionality in detail.
In-Depth Stored Procedure Review
For each stored procedure, it provides a detailed description and its functionality, including data selection, joins, associated tables and views, sorting, and other essential information. This ensures a complete understanding of the procedure’s role and operations within the database.
T-SQL Query for Stored procedures
Also, it includes the complete SQL query for each stored procedure, enabling you to analyze and understand its logic and implementation in detail.