If you selected a database, user or table object to compare, and it has dependent objects you want to include in the comparison, select these objects in the Compare Objects screen. If an object has no dependent objects, the screen displays as blank.
Including dependent objects is an optional step. By default, the Compare SQL Object Wizard compares only the object you select with the referenced object.
You can include dependent objects to be included in the comparison of database, user, and table objects. When comparing database or user objects, the Compare SQL Object Wizard gives you the option to include child databases and users, functions, hash and join indexes, macros, stored procedures, tables, triggers, and views. If you are comparing tables, you can include dependent triggers in the DDL comparison.