Viewing Tables or Views Utilizing User Interface Defaults

Click the Application Builder icon on the Workspace home page.

Select an application.

On the Application home page, click Shared Components.

The Shared Components page appears.

Under User Interface, select User Interface Defaults.

The User Interface Defaults page appears.

The current schema displays to the right of the breadcrumb menu.

To select a new schema, make a selection from the Schema list.

To narrow the display, use the following controls at the top of the page and click Go:

• Table/View - Enter a case insensitive query for a table or view name within the current schema.

• View - Make a selection to filter the view:

  • Icons (default) displays each table or view as large icon.

  • Details displays each table or view as a line in a report, identifying the table or view name, the object type, and whether or not user interface defaults currently exist.

  • Display determines the number of items that display in the report.

Select a specific table or view by selecting the name.

The Table Defaults page appears.

If no user interface defaults exist, click Create User Interface Defaults.

Navigate to Object Browser:

1. Click the SQL Workshop icon on the Workspace home page.

2. Click Object Browser.

   Object Browser appears.

From the Object list, select either Tables or Views.

From the Object Selection pane, select an object.

Select the UI Defaults tab.

The User Interface Defaults report appears displaying the following information:

• Column Name - Indicates the name of the column.

• Label - Specifies the default label text for items in a form and the heading for columns in reports.

• Report Sequence - Specifies the sequence of items in a report.

• Report Display - Specifies how the column should be displayed in a report.

• Tabular Form Display - Specifies how an item should display in a tabular form.

• Form Sequence - Specifies the sequence of items in a form.

• Form Display - Specifies how items in a form display.

To edit the user interface defaults, click Edit.

The Table Defaults page appears.

If no user interface defaults exist, click Create Defaults.