Dependencies Analyzer Module provides you with the functionality required to analyze dependencies between database objects including referential integrity constraints between database tables, call tree dependencies for stores procedures and triggers, 'up' and 'down' dependencies between any object types.
Dependencies Analyzer Module also provides powerful database search function, which allows to search for any object usage pattern within single or multiple databases or any text string within a 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 those operation on your entire back-end system integrity.
Results of DB search or dependencies analysis is 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.
If required, you can immediately navigate to the corresponding object editor to modify or remove the selected object dependency.