SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

order by schema_name, table_name
for read uncommitted access;
SCHEMA_NAME
------------------------------
TABLE_NAME
-------------------------
DEFINITION_SCHEMA_VERSION_3000
DEFINITION_SCHEMA_VERSION_3000
ACCESS_PATHS
ACCESS_PATH_COLS
DEFINITION_SCHEMA_VERSION_3000CK_COL_USAGE
DEFINITION_SCHEMA_VERSION_3000CK_TBL_USAGE
DEFINITION_SCHEMA_VERSION_3000COLS
DEFINITION_SCHEMA_VERSION_3000COL_PRIVILEGES
DEFINITION_SCHEMA_VERSION_3000DDL_LOCKS
DEFINITION_SCHEMA_VERSION_3000DDL_PARTITION_LOCKS
DEFINITION_SCHEMA_VERSION_3000EXCEPTION_USAGE
DEFINITION_SCHEMA_VERSION_3000KEY_COL_USAGE
DEFINITION_SCHEMA_VERSION_3000MP_PARTITIONS
DEFINITION_SCHEMA_VERSION_3000MVGROUPS
DEFINITION_SCHEMA_VERSION_3000MVS
DEFINITION_SCHEMA_VERSION_3000MVS_COLS
DEFINITION_SCHEMA_VERSION_3000MVS_JOIN_COLS
DEFINITION_SCHEMA_VERSION_3000MVS_TABLE_INFO
DEFINITION_SCHEMA_VERSION_3000MVS_USED
DEFINITION_SCHEMA_VERSION_3000OBJECTS
DEFINITION_SCHEMA_VERSION_3000PARTITIONS
DEFINITION_SCHEMA_VERSION_3000REF_CONSTRAINTS
DEFINITION_SCHEMA_VERSION_3000REPLICAS
DEFINITION_SCHEMA_VERSION_3000RI_UNIQUE_USAGE
DEFINITION_SCHEMA_VERSION_3000ROUTINES
DEFINITION_SCHEMA_VERSION_3000SCH_PRIVILEGES
DEFINITION_SCHEMA_VERSION_3000SEQUENCE_GENERATORS
DEFINITION_SCHEMA_VERSION_3000SG_USAGE
DEFINITION_SCHEMA_VERSION_3000SYNONYM_USAGE
DEFINITION_SCHEMA_VERSION_3000TBL_CONSTRAINTS
DEFINITION_SCHEMA_VERSION_3000TBL_PRIVILEGES
DEFINITION_SCHEMA_VERSION_3000TEXT
DEFINITION_SCHEMA_VERSION_3000TRIGGERS
DEFINITION_SCHEMA_VERSION_3000TRIGGERS_CAT_USAGE
DEFINITION_SCHEMA_VERSION_3000TRIGGER_USED
DEFINITION_SCHEMA_VERSION_3000VWS
DEFINITION_SCHEMA_VERSION_3000VW_COL_TBL_COLS
DEFINITION_SCHEMA_VERSION_3000VW_COL_USAGE
DEFINITION_SCHEMA_VERSION_3000VW_TBL_USAGE
INVENTHISTOGRAMS
INVENTHISTOGRAMS_FREQ_VALS
INVENTHISTOGRAM_INTERVALS
INVENTMVS_TABLE_INFO_UMD
INVENTMVS_UMD
INVENTMVS_USED_UMD
INVENTPARTLOC
INVENTPARTSUPP
INVENTSUPPLIER
INVENTT1
PERSNLDEPT
PERSNLEMPLOYEE
PERSNLHISTOGRAMS
PERSNLHISTOGRAMS_FREQ_VALS
PERSNLHISTOGRAM_INTERVALS
PERSNLJOB
PERSNLMVS_TABLE_INFO_UMD
PERSNLMVS_UMD
PERSNLMVS_USED_UMD
PERSNLPROJECT
SALESCUSTOMER
SALESHISTOGRAMS
SALESHISTOGRAMS_FREQ_VALS
SALESHISTOGRAM_INTERVALS
SALESMVS_TABLE_INFO_UMD
SALESMVS_UMD
SALESMVS_USED_UMD
SALESODETAIL
126 Querying SQL/MX Metadata