db2 => describe table sysibm.systables
Data type Column
Column name schema Data type name Length Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
NAME SYSIBM VARCHAR 128 0 No
CREATOR SYSIBM VARCHAR 128 0 No
TYPE SYSIBM CHARACTER 1 0 No
CTIME SYSIBM TIMESTAMP 10 6 No
REMARKS SYSIBM VARCHAR 254 0 Yes
PACKED_DESC SYSIBM BLOB 133169152 0 Yes
VIEW_DESC SYSIBM BLOB 4190000 0 Yes
COLCOUNT SYSIBM SMALLINT 2 0 No
FID SYSIBM SMALLINT 2 0 No
TID SYSIBM SMALLINT 2 0 No
CARD SYSIBM BIGINT 8 0 No
NPAGES SYSIBM BIGINT 8 0 No
FPAGES SYSIBM BIGINT 8 0 No
OVERFLOW SYSIBM BIGINT 8 0 No
PARENTS SYSIBM SMALLINT 2 0 Yes
CHILDREN SYSIBM SMALLINT 2 0 Yes
SELFREFS SYSIBM SMALLINT 2 0 Yes
KEYCOLUMNS SYSIBM SMALLINT 2 0 Yes
KEYOBID SYSIBM SMALLINT 2 0 Yes
REL_DESC SYSIBM BLOB 262144 0 Yes
BASE_NAME SYSIBM VARCHAR 128 0 Yes
BASE_SCHEMA SYSIBM VARCHAR 128 0 Yes
TBSPACE SYSIBM VARCHAR 128 0 Yes
INDEX_TBSPACE SYSIBM VARCHAR 128 0 Yes
LONG_TBSPACE SYSIBM VARCHAR 128 0 Yes
KEYUNIQUE SYSIBM SMALLINT 2 0 No
CHECKCOUNT SYSIBM SMALLINT 2 0 No
CHECK_DESC SYSIBM BLOB 131072 0 Yes
STATS_TIME SYSIBM TIMESTAMP 10 6 Yes
DEFINER SYSIBM VARCHAR 128 0 No
TRIG_DESC SYSIBM BLOB 3145728 0 Yes
DATA_CAPTURE SYSIBM CHARACTER 1 0 No
STATUS SYSIBM CHARACTER 1 0 No
CONST_CHECKED SYSIBM CHARACTER 32 0 No
PMAP_ID SYSIBM SMALLINT 2 0 Yes
ENCODING_SCHEME SYSIBM CHARACTER 1 0 No
PCTFREE SYSIBM SMALLINT 2 0 No
ROWTYPESCHEMA SYSIBM VARCHAR 128 0 Yes
ROWTYPENAME SYSIBM VARCHAR 128 0 Yes
APPEND_MODE SYSIBM CHARACTER 1 0 No
PARTITION_MODE SYSIBM CHARACTER 1 0 No
REFRESH SYSIBM CHARACTER 1 0 No
REFRESH_TIME SYSIBM TIMESTAMP 10 6 Yes
LOCKSIZE SYSIBM CHARACTER 1 0 No
VOLATILE SYSIBM CHARACTER 1 0 No
REMOTE_DESC SYSIBM BLOB 10485760 0 Yes
CLUSTERED SYSIBM CHARACTER 1 0 Yes
AST_DESC SYSIBM BLOB 535822336 0 Yes
DROPRULE SYSIBM CHARACTER 1 0 No
LOGINDEXBUILD SYSIBM CHARACTER 1 0 No
PROPERTY SYSIBM VARCHAR 32 0 No
STATISTICS_PROFILE SYSIBM CLOB 10485760 0 Yes
COMPRESSION SYSIBM CHARACTER 1 0 No
ACCESS_MODE SYSIBM CHARACTER 1 0 No
ACTIVE_BLOCKS SYSIBM BIGINT 8 0 No
MAXFREESPACESEARCH SYSIBM SMALLINT 2 0 No
AVGCOMPRESSEDROWSIZE SYSIBM SMALLINT 2 0 No
AVGROWCOMPRESSIONRATIO SYSIBM REAL 4 0 No
AVGROWSIZE SYSIBM SMALLINT 2 0 No
PCTROWSCOMPRESSED SYSIBM REAL 4 0 No
CODEPAGE SYSIBM SMALLINT 2 0 No
PCTPAGESSAVED SYSIBM SMALLINT 2 0 No
LAST_REGEN_TIME SYSIBM TIMESTAMP 10 6 Yes
SECPOLICYID SYSIBM INTEGER 4 0 No
PROTECTIONGRANULARITY SYSIBM CHARACTER 1 0 No
INVALIDATE_TIME SYSIBM TIMESTAMP 10 6 No
DEFINERTYPE SYSIBM CHARACTER 1 0 No
ALTER_TIME SYSIBM TIMESTAMP 10 6 No
AUDITPOLICYID SYSIBM INTEGER 4 0 Yes
COLLATIONID SYSIBM CHARACTER 8 0 No
COLLATIONID_ORDERBY SYSIBM CHARACTER 8 0 No
ONCOMMIT SYSIBM CHARACTER 1 0 No
ONROLLBACK SYSIBM CHARACTER 1 0 No
LOGGED SYSIBM CHARACTER 1 0 No
LASTUSED SYSIBM DATE 4 0 No
CONTROL SYSIBM CHARACTER 1 0 No
CONTROLS_DESC SYSIBM BLOB 4194304 0 Yes
ROWCOMPMODE SYSIBM CHARACTER 1 0 No
AUDITEXCEPTION_DESC SYSIBM BLOB 4190000 0 Yes
AUDITEXCEPTIONENABLED SYSIBM CHARACTER 1 0 No
MPAGES SYSIBM BIGINT 8 0 No
EXTENDED_ROW_SIZE SYSIBM CHARACTER 1 0 No
PCTEXTENDEDROWS SYSIBM REAL 4 0 No
83 record(s) selected.
db2 =>
收起