The Dependencies Analyzer helps you to analyze dependencies between database objects, including referential integrity constraints, call tree dependencies for stores procedures and triggers, and 'up' and 'down' dependencies for any object types.
The Dependencies Analyzer also provides powerful database search function, which allows searching for any object usage pattern within single or multiple databases or any text string within stored database object syntax.
The dependencies analysis can be invoked on demand or when you attempt to drop a database object or a single table column to see immediate impact of that operation on your entire back-end system integrity.
Results of DB search or dependencies analysis are presented in the form of convenient dependencies trees with a drill-down capabilities, which allows to see not only the list of dependent objects but also examine the exact object usage context and SQL syntax. Dependencies reports can be viewed on the screen and printed.
If required, you can immediately navigate to the corresponding object editor to modify or remove the selected object dependency.
In addition, the Dependencies view is integrated with Entity Relationship diagram to allow a comprehensive graphical and hierarchical analysis.