kingbaseES基础 sys_class 查看视图

原创云散月明 All China Database Union 2022-07-11

301

Server：CentOS 7.2.1511
KingbaseES：V8R6C5B23

sys_class 查看视图

test2=# \x
扩展显示已打开.
test2=# select * from sys_class where relname='my_view1';
-[ RECORD 1 ]-------+---------
oid                 | 16398
relname             | my_view1
relnamespace        | 2200
reltype             | 16400
reloftype           | 0
relowner            | 10
relam               | 0
relfilenode         | 0
reltablespace       | 0
relpages            | 0
reltuples           | 0
relallvisible       | 0
reltoastrelid       | 0
relhasindex         | f
relisshared         | f
relpersistence      | p
relkind             | v
relnatts            | 1
relchecks           | 0
relhasrules         | t
relhastriggers      | f
relhassubclass      | f
relrowsecurity      | f
relforcerowsecurity | f
relispopulated      | t
relreplident        | n
relispartition      | f
relrewrite          | 0
relfrozenxid        | 0
relminmxid          | 0
relacl              | 
reloptions          | 
relpartbound        | 

test2=# \d my_view1 
          视图 "public.my_view1"
 栏位 |  类型   | 校对规则 | 可空的 | 预设 
------+---------+----------+--------+------
 c1   | integer |          |        | 

test2=# \d+ my_view1 
                  视图 "public.my_view1"
 栏位 |  类型   | 校对规则 | 可空的 | 预设 | 存储  | 描述 
------+---------+----------+--------+------+-------+------
 c1   | integer |          |        |      | plain | 
视图定义:
 SELECT t1.c1
   FROM t1;