TABLE Selection

The TABLE selection accesses the Table Display Facility (see the following figure). With this facility, you can locate and display tables by specified filtering criteria. The fast-path command for this facility is MENU.TB.

Table Display Facility. This window is maximized.

See Filtering Selections for selections not listed below.

TEMP

Displays global temporary tables.

AUXILIARY

Displays all auxiliary tables.

MAT_QUERY

Displays all Materialized Query Tables (all tables with table type ’M’).

XML

Displays all Implicit tables for XML columns (table type ’P’).

CLONE

Displays all Clone Tables (all tables with table type ’C’).

HISTORY

Displays all History (Temporal) Tables (all tables with table type ’H’).

TRIGGER

Opens the Trigger Display Facility. See Trigger Display Facility.

DATATYPE

Opens the User Defined Data Type Display Facility. See User Defined Data Type Display Facility.

ID

Opens the Identity Columns Menu. See Identity Column Display Facility.

COLUMNS

Opens the Column Display Facility. See Column Display Facility.

MASK

Opens the Column Mask Display Facility. See Column Mask Display Facility.

Table Display Facility (Scrolled)

PERMISSION

Opens the Permission Display Facility. See Row Permission Display Facility.

CHECKS

Opens the Check Constraint Display Facility. See Check Display Facility.

CALC

Calculates tablespace requirements. CALC is also available as a row command (CALC-Space-Calculate) and as a primary command (CALC-Space-Calculation).

Trigger Display Facility

The TRIGGER selection from the Table Display Facility accesses the Trigger Display Facility (see the following figure). With this facility, you can locate and display triggers by specified filtering criteria.

Trigger Display Facility. This window is maximized.

See Filtering Selections for selections not listed below.

OWNER

Opens a WHERE clause to select triggers by owner.

OWNER_NAME

Opens a WHERE clause to select triggers by owner and name.

SCHEMA

Opens a WHERE clause to select triggers by schema name.

TABLE

Opens a WHERE clause to select triggers by table owner and table name.

User Defined Data Type Display Facility

The DATATYPE selection from the Table Display Facility accesses the User Defined Data Type Display Facility (see the following figure). With this facility, you can locate and display user-defined data types by specified filtering criteria.

User Defined Data Type Display Facility. This window is maximized.

See Filtering Selections for selections not listed below.

SCHEMA

Opens a WHERE clause to select user-defined data types by schema name.

SCHEMA_NAME

Opens a WHERE clause to select user-defined data types by schema and name.

Identity Column Display Facility

The ID selection from the Table Display Facility accesses the Identity Column Display Facility (see the following figure). With this facility, you can locate and display Identity Columns by specified filtering criteria. The fast-path command for this facility is MENU.TB.ID. See Filtering Selections for a description of the selections.

Identity Column Display Facility. This window is maximized.

Column Display Facility

The COLUMNS selection from the Table Display Facility accesses the Column Display Facility (see the following figure). With this facility, you can locate and display columns by specified filtering criteria. The fast-path command for this facility is MENU.TB.CL. See Filtering Selections for a description of the selections.

Column Display Facility. This window is maximized.

Column Mask Display Facility

The MASK selection from the Table Display Facility accesses the Column Mask Display Facility (see the following figure). With this facility, you can locate and display column masks by specified filtering criteria. The fast-path command for this facility is MENU.TB.MASK.

Column Mask Display Facility. This window is maximized.

See Filtering Selections for selections not listed below.

SCHEMA

Opens a WHERE clause to select user-defined data types by schema name.

Row Permission Display Facility

The PERMISSION selection from the Table Display Facility accesses the Row Permission Display Facility (see the following figure). With this facility, you can locate and display row permissions by specified filtering criteria. The fast-path command for this facility is MENU.TB.PERM.

Row Permission Display Facility. This window is maximized.

See Filtering Selections for selections not listed below.

SCHEMA

Opens a WHERE clause to select user-defined data types by schema name.

Check Display Facility

The CHECKS selection from the Table Display Facility accesses the Check Constraint Display Facility (see the following figure). With this facility, you can locate and display check constraints by specified filtering criteria.

Check Constraint Display Facility. This window is maximized.

See Filtering Selections for selections not listed below.

CHECKNAME

Opens a WHERE clause to select objects by check name.

TBCREATOR

Opens a WHERE clause to select objects by table creator.

TBNAME

Opens a WHERE clause to select objects by table name.