View information about columns, indexes, references, privileges,
user-defined data types (UDTs), constraints, fragments, and triggers.
- On menu for the HCL OpenAdmin Tool (OAT) for Informix®, click .
- To find a table, type any part of the
table name in the Find field, and click Search.
You can also expand a database to display the tables.
- Optional: Select the filters to include more
tables in the list:
- To include system catalogs, select Include Catalogs.
- To include views, select Include Views.
A view is a virtual table based on a specified SELECT statement.
- To include synonyms, select Include Synonyms.
A synonym is an alternative name for a table, a view, or a sequence
object. Typically, synonyms refer to tables that are not in the current
database.
- Select the table in the list.
The page
displays a panel of information for each of the table objects.
- To display more details about a table object, click the
expand button on the object panel.