Exception Reports

Use the Exception Reports to view unindexed foreign keys and tables without primary keys, indexes, or triggers.

To view Exception reports:

1. On the Workspace home page, click the SQL Workshop.

2. Click Utilities.

3. Click Object Reports.

   The Object Reports page appears.

4. In the Exception Reports section, click the report you want to view.

   • Tables without Primary Keys

   • Tables without Indexes

   • Unindexed Foreign Keys

   • Tables without Triggers

5. To filter the report, enter a table name and click Go. See Customizing Interactive Reports in the Oracle Application Express Application Builder User's Guide for further details.

6. To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.