Show Related

The Show Related notebook shows first-level subordinate dependencies for the selected object. To view second-level dependencies, you must select Show Related for each first-level dependency object that exists.

For example, if you want to drop Table A you can select Show Related on the Table A object to find out what views are affected. On the Views page of the Show Related notebook for Table A you see View A, because it has a first-level dependency on Table A. If another view, View B, is built on View A, it would have a first-level dependency on View A and a second-level dependency on Table A. View B is not listed in the Show Related notebook for Table A. You must right-click on the View A object in the notebook and select Show Related from the pop-up menu to see the View B dependency on View A.

Authorities and privileges

The Show Related notebook pages vary according to the object that you select. Select any object below to see other objects relating to it.