Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Lynn Armbruster: "Thank you. I found Maestro easy to use and so far a great tool".
Paolo Benjamin T. Briones: "I just downloaded the trial and its great! IMHO, its a lot better than the Enterprise Manager from SQL Server".

More

Add your opinion

MS SQL Maestro online Help

Prev Return to chapter overview Next

Dependency tracker

Dependency tracker is a tool to browse all-level dependencies of a schema object (table, view, function, etc). To display dependencies of an object, drag and drop it from the Explorer tree (or Object Manager, Object Browser) to the tracker's working area.

 

This tool allows you to see the way any database object is involved in the net of scheme dependencies. The selected object is displayed in a highlighted rectangle in the center of the working area. The right side of this area represents objects depending on the selected one. The left side represents objects on which the selected object depends.

 

To highlight all occurrences of an object in the diagram, click the appropriate rectangle. Double click an object to change the tracker focus to this object. Right click a rectangle to display a popup menu with common operations related to the appropriate object.

 

 

The recursive dependencies are marked with a semicircle. This means marked object depends on itself directly or via other objects.

 

Example

Suppose we have two procedures A and B calling each other. The tracker displays these dependencies in the following way:

 

 

 



Prev Return to chapter overview Next