DB2系统内置——SYSCAT.TABLES 所有的字段说明

最新推荐文章于 2023-08-29 17:00:21 发布

weixin_30276935

最新推荐文章于 2023-08-29 17:00:21 发布

阅读量2.1k

点赞数 1

文章标签：数据库人工智能

原文链接：http://www.cnblogs.com/wy20110919/p/9068588.html

版权

本文介绍了DB2的SYSCAT.TABLES目录视图，它包含每张表、视图、别名或昵称的详细信息，包括层次结构表和视图。该视图也涵盖目录表和视图。

摘要由CSDN通过智能技术生成

SYSCAT.TABLES catalog view

Each row represents a table, view, alias, or nickname. Each table or view hierarchy has one additional row representing the hierarchy table or hierarchy view that implements the hierarchy. Catalog tables and views are included.

每一行代表一张表，视图，别名或昵称。每个表或视图层次结构都有一个额外的行，代表实现层次结构的层次结构表或层次结构视图。包括目录表和视图。

Table 67. SYSCAT.TABLES Catalog View
Column Name	Data Type	Nullable	Description
TABSCHEMA	VARCHAR(128)		Schema name of the object.
TABNAME	VARCHAR(128)		Unqualified name of the object.
OWNER	VARCHAR(128)		Authorization ID under which the table, view, alias, or nickname was created.
TYPE	CHAR(1)		Type of object. A = Alias G = Global temporary table H = Hierarchy table L = Detached table N = Nickname S = Materialized query table T = Table (untyped) U = Typed table V = View (untyped) W = Typed view
STATUS	CHAR(1)		Status of the object. C = Set integrity pending N = Normal X = Inoperative
BASE_TABSCHEMA	VARCHAR(128)	Y	If TYPE = 'A', contains the schema name of the table, view, alias, or nickname that is referenced by this alias; null value otherwise.
BASE_TABNAME	VARCHAR(128)	Y	If TYPE = 'A', contains the unqualified name of the table, view, alias, or nickname that is referenced by this alias; null value otherwise.
ROWTYPESCHEMA	VARCHAR(128)	Y	Schema name of the row type for this table, if applicable; null value otherwise.
ROWTYPENAME	VARCHAR(128)	Y	Unqualified name of the row type for this table, if applicable; null value otherwise.
CREATE_TIME	TIMESTAMP		Time at which the object was created.
INVALIDATE_TIME	TIMESTAMP		Time at which the object was last invalidated.
STATS_TIME	TIMESTAMP	Y	Time at which any change was last made to recorded statistics f