Viewing Underlying Database Objects

Viewing the Database Object Dependencies Report

The Database Object Dependencies report identifies database objects referenced by the current application. Review this report to determine what objects to move when deploying an application.

To view the Database Object Dependencies report:

1. Navigate to the Workspace home page.

2. Click the Application Builder icon.

3. Select an application.

   The Application home page appears.

4. On the Tasks list, click Application Reports.

5. Click Shared Components.

6. Under Application, click Database Object Dependencies.

7. Click Compute Dependencies.

8. To view the components that reference a specific database object, select the Reference Count number.

Viewing Database Objects in Object Browser

To view the database objects in Object Browser:

1. On the Workspace home page, click SQL Workshop and then Object Browser.

   Object Browser appears.

2. Select an object type from the Object list in the upper left corner of the page. For example, to view tables, select Tables.

3. To search for an object name, enter keywords in the search field beneath the Object list.

   A list of matching objects appears.

   
   Description of the illustration demo_obrws_srch.gif
   
   

4. To perform a specific task related to the selected object, select the appropriate task button.

   For example, to modify a column in the DEMO_CUSTOMERS table:

   1. From the Objects list, select Tables.

   2. From the Tables list, select DEMO_CUSTOMERS.

   3. Click Modify Column.

5. To view additional object details, select a tab beneath the object name. For example, to view the data in the DEMO_CUSTOMERS table:

   1. From the Tables list, select DEMO_CUSTOMERS.

   2. Select the Data tab.

      A report appears that displays the data in the DEMO_CUSTOMERS table appears.

   
   Description of the illustration demo_data.gif