Viewing table objects

View information about columns, indexes, references, privileges, user-defined data types (UDTs), constraints, fragments, and triggers.

To view table objects:

  1. On menu for the HCL OpenAdmin Tool (OAT) for Informix®, click SQL Toolbox > Schema Manager.
  2. 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.
  3. 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.
  4. Select the table in the list.

    The page displays a panel of information for each of the table objects.

  5. To display more details about a table object, click the expand button on the object panel.

Copyright© 2018 HCL Technologies Limited