SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—523723-004
8-49
Displaying Column Information
•
Displaying All Columns in a Referential Integrity Constraint on page 8-55
•
Displaying the Attributes of a Column on page 8-56
•
Displaying All Tables Containing a Selected Column on page 8-57
Related topic:
•
Displaying All Privileges for a Column on page 8-61
The COLS table, located in the schema
DEFINITION_SCHEMA_VERSION_version-number of each catalog, describes the
columns in all tables and views in that catalog. For detailed information about all
metadata tables, see Table 8-1 on page 8-6 or the SQL/MX Reference Manual.
All queries for information about columns must access information from the CATSYS,
SCHEMATA, and OBJECTS tables, and from other appropriate tables, such as the
COLS table.
You can also use the MXCI SHOWDDL command to display the approximate CREATE
TABLE statement that might have created the columns in that table. For examples of
the SHOWDDL command, see the SQL/MX Reference Manual.