Function Insights
Similar to stored procedures, DB Insights provides a deep dive into user-defined functions, revealing dependencies, logic, and data manipulation details.
Key Capabilities
Functional Descriptions
AI-generated summaries explaining each function’s purpose and data manipulations.
Code Transparency
Displays the T-SQL definition separately for thorough review and troubleshooting. This offers the complete script for accuracy checks and auditing.
Dependency Insights
Shows which tables, views, or stored procedures the function references, including hidden or implicit relationships.
List of Functions
DB Insights portal lists all the available functions in the database, offering a clear overview of their purpose and availability.
Comprehensive Function Analysis
For each function, it provides a detailed description and its functionality, including data selection, joins, associated tables and views, sorting, and other essential details. Additionally, it offers valuable insights such as the tables used and key relationships, ensuring a thorough understanding of each function’s role in the database.
T-SQL Query for Functions
DB Insights also provides the complete SQL query for each function, allowing you to analyze its logic and implementation in depth.