SYSCAT.TABLES所有的字段说明
SYSCAT.TABLES catalog view
Each row reprents a table, view, alias, or nickname. Each table or view hierarchy has one additional row reprenting the hierarchy table or hierarchy view that implements the hierarchy. Catalog tables and views are included.
NPAGES BIGINT Total number of pages on which the rows of the table exist; -1 for a view or alias, or if statistics are not collected; -2 for a subtable or hierarchy table.
FPAGES BIGINT Total number of pages; -1 for a view or alias, or if statistics are not collected; -2 for a subtable or hierarchy table.
OVERFLOW BIGINT Total number of overflow records in the table; -1 for a view or alias, or if statistics are not collected; -2 for a subtable or hierarchy table.
TBSPACE VARCHAR(128)Y Name of the primary table space for the table. If no other table space is specified, all parts of the table are stored in this table space. Null for alias, views, and partitioned tables.
INDEX_TBSPACE VARCHAR(128)Y Name of the table space that holds all indexes created on this table. Null for alias, views, and partitioned tables, or if the INDEX IN clau was omitted or specified with the same value as the IN clau of the CREATE TABLE statement.
LONG_TBSPACE VARCHAR(128)Y Name of the table space that holds all long data (LONG or LOB column types) for this table. Null for alias, views, and partitioned tables, or if the LONG IN clau was omitted or specified with the same value as the IN clau of the CREATE TABLE statement.
PARENTS SMALLINT Y Number of parent tables for this object; that is, the number of referential constraints in which this object is a dependent.
CHILDREN SMALLINT Y Number of dependent tables for this object; that is, the number of referential constraints in which this object is a parent.
SELFREFS SMALLINT Y Number of lf-referencing referential constraints for this object; that is, the number of referential constraints in which this object is both a parent and a dependent.修改字体
KEYCOLUMNS SMALLINT Y Number of columns in the primary key.
KEYINDEXID SMALLINT Y Index identifier for the primary key index; 0 or the null value if there is no primary key.
KEYUNIQUE SMALLINT Number of unique key constraints (other than the primary key constraint) defined on this object.
CHECKCOUNT SMALLINT Number of check constraints defined on this object.
DATACAPTURE CHAR(1)L = Table participates in data replication, including replication of LONG VARCHAR and LONG VARGRAPHIC columns
N = Table does not participate in data replication
Y = Table participates in data replication, excluding replication of LONG VARCHAR and LONG VARGRAPHIC columns
CONST_CHECKED CHAR(32)
Byte 1 reprents foreign key constraint.
Byte 2 reprents check constraint.
Byte 5 reprents materialized query table.
Byte 6 reprents generated column.
Byte 7 reprents staging table.
Byte 8 reprents data partitioning constraint.
Other bytes are rerved for future u.
Possible values are:
魏克田
年轻的心
F = In byte 5, the materialized query table
CONST_CHECKED CHAR(32) F = In byte 5, the materialized query table
cannot be refreshed incrementally. In byte 7, the
梦见玉镯碎了content of the staging table is incomplete and
cannot be ud for incremental refresh of the
associated materialized query table.
N = Not checked
U = Checked by ur
W = Was in 'U' state when the table was placed
in t integrity pending state
Y = Checked by system
PMAP_ID SMALLINT Y Identifier for the distribution map that is currently in u by this table (null for alias or views).
PARTITION_MODE CHAR(1)Indicates how data is distributed among databa partitions in a partitioned databa system.
H = Hashing
R = Replicated across databa partitions
Blank = No databa partitioning
LOG_ATTRIBUTE CHAR(1)
Always 0. This column is no longer ud. PCTFREE SMALLINT Percentage of each page to be rerved for future inrts.
APPEND_MODE CHAR(1)Controls how rows are inrted into pages.
N = New rows are inrted into existing spaces, if available
Y = New rows are appended to the end of the
data
Initial value is 'N'.
REFRESH CHAR(1)Refresh mode.
D = Deferred
I = Immediate
O = Once
Blank = Not a materialized query table
REFRESH_TIME TIMESTAMP Y For REFRESH = 'D' or 'O', time at which the data was last refreshed (REFRESH TABLE statement); null value otherwi.
LOCKSIZE CHAR(1)Indicates the preferred lock granularity for tables that are accesd by data manipulation language (DML) statements. Applies to tables only. Possible values are:
I = Block inrt
R = Row
T = Table
Blank = Not applicable
Initial value is 'R'.
VOLATILE CHAR(1)C = Cardinality of the table is volatile Blank = Not applicable
ROW_FORMAT CHAR(1)Not ud.
ROW_FORMAT CHAR(1)Not ud.
PROPERTY VARCHAR(32)Properties for a table. A single blank indicates that the table has no properties.
STATISTICS_PROFILE CLOB(10M)Y RUNSTATS command ud to register a statistical profile for the object.
COMPRESSION CHAR(1)B = Both value and row compression are activated
N = No compression is activated; a row format that does not support compression is ud
R = Row compression is activated; a row format that supports compression might be ud
V = Value compression is activated; a row format that supports compression is ud Blank = Not applicable
ACCESS_MODE CHAR(1)Access restriction state of the object. The states only apply to objects that are in t integrity pending state or to objects that were procesd by a SET INTEGRITY statement. Possible values are:
揭开的意思D = No data movement
F = Full access
N = No access
R = Read-only access
CLUSTERED CHAR(1)Y Y = Table is multidimensionally clustered (even if only by one dimension)幼儿个案观察记录
Null value = Table is not multidimensionally clustered
ACTIVE_BLOCKS BIGINT Total number of active blocks in the table, or -1. Applies to multidimensional clustering (MDC) tables only.
DROPRULE CHAR(1)N = No rule
R = Restrict rule applies on drop
china的音标
MAXFREESPACESEARCH SMALLINT Rerved for future u.
AVGCOMPRESSEDROWSIZE SMALLINT Average length (in bytes) of compresd rows in this table; -1 if statistics are not collected.
AVGROWCOMPRESSIONRATIO REAL For compresd rows in the table, this is the average compression ratio by row; that is, the average uncompresd row length divided by the average compresd row length; -1 if statistics are not collected.
AVGROWSIZE SMALLINT Average length (in bytes) of both compresd and uncompresd rows in this table; -1 if statistics are not collected.
PCTROWSCOMPRESSED REAL Compresd rows as a percentage of the total number of rows in the table; -1 if statistics are not collected.
LOGINDEXBUILD VARCHAR(3)Y Level of logging that is to be performed during create, recreate, or reorganize index operations on the table.
OFF = Index build operations on the table will
be logged minimally
ON = Index build operations on the table will be logged completely
LOGINDEXBUILD VARCHAR(3)Y logged completely
Null value = Value of the logindexbuilddataba
configuration parameter will be ud to
determine whether or not index build operations
are to be completely logged
CODEPAGE SMALLINT Code page of the object. This is the default code page ud for all character columns, triggers, check constraints, and expression-generated columns.
ENCODING_SCHEME CHAR(1)A = CCSID ASCII was specified靖江王陵
U = CCSID UNICODE was specified Blank = CCSID clau was not specified
PCTPAGESSAVED SMALLINT Approximate percentage of pages saved in the table as a result of row compression. This value includes overhead bytes for each ur data row in the table, but does not include the space that is consumed by dictionary overhead; -1 if statistics are not collected.
LAST_REGEN_TIME TIMESTAMP Time at which any views or check constraints on the table were last regenerated.
SECPOLICYID INTEGER Identifier for the curity policy protecting the table; 0 for non-protected tables.
PROTECTIONGRANULARITY CHAR(1)B = Both column- and row-level granularity
C = Column-level granularity
R = Row-level granularity
Blank = Non-protected table
DEFINER1VARCHAR(128)Authorization ID under which the table, view, alias, or nickname was created.
REMARKS VARCHAR(254)Y Ur-provided comments, or null. Notes:
1. The DEFINER column is included for backwards compatibility. See OWNER.
