| 
TABLE COLUMN COLUMN COLUMN COLUMN COLUMN LABEL NAME NUMBER NAME TYPE LENGTH SCALE ------------------------------------------------------------------------------- SYSTABLES 1 NAME CHAR 10 0 TABLE 2 CREATOR CHAR 10 0 AUTHORIZATION ID 3 TYPE CHAR 1 0 TYPE 4 COLCOUNT SMALLINT 2 0 COLUMN 5 RECLENGTH SMALLINT 2 0 RECORD 6 LABEL CHAR 30 0 LABEL 7 REMARKS CHAR 254 0 REMARKS 8 DBNAME CHAR 10 0 DATABASE SYSCOLUMNS 1 NAME CHAR 10 0 COLUMN 2 TBNAME CHAR 10 0 TABLE 3 TBCREATOR CHAR 10 0 TABLE 4 COLNO SMALLINT 2 0 COLUMN 5 COLTYPE CHAR 8 0 COLUMN 6 LENGTH SMALLINT 2 0 COLUMN 7 SCALE SMALLINT 2 0 COLUMN 8 NULLS CHAR 1 0 NULLS 9 UPDATES CHAR 1 0 UPDATES |
|
10 REMARKS CHAR 254 0 REMARKS 11 DEFAULT CHAR 1 0 DEFAULTS 12 LABEL CHAR 30 0 LABEL 13 STORAGE SMALLINT 2 0 STORAGE 14 PRECISION SMALLINT 2 0 PRECISION SYSINDEXES 1 NAME CHAR 10 0 NAME 2 CREATOR CHAR 10 0 CREATOR 3 TBNAME CHAR 10 0 TBNAME 4 TBCREATOR CHAR 10 0 TBCREATOR 5 TBDBNAME CHAR 10 0 TBDBNAME 6 UNIQUERULE CHAR 1 0 DUP 7 COLCOUNT INTEGER 4 0 COLCOUNT 8 DBNAME CHAR 10 0 DBNAME SYSKEYS 1 IXNAME CHAR 10 0 FILE 2 IXCREATOR CHAR 10 0 FILE 3 COLNAME CHAR 10 0 EXTERNAL 4 COLNO INTEGER 4 0 OUTPUT 5 COLSEQ INTEGER 4 0 REL 6 ORDERING CHAR 1 0 KEY |
|
SYSVIEWS 1 NAME CHAR 10 0 FILE 2 CREATOR CHAR 10 0 FILE 3 SEQNO INTEGER 4 0 REL 4 CHECK CHAR 1 0 SQL 5 TEXT CHAR 70 0 SQL SYSVIEWDEP 1 DNAME CHAR 10 0 DEPENDENT 2 DCREATOR CHAR 10 0 FILE 3 BNAME CHAR 10 0 BNAME 4 BCREATOR CHAR 10 0 BCREATOR 5 BDBNAME CHAR 10 0 BDBNAME 6 BTYPE CHAR 1 0 BTYPE |
