KingbaseESV7确定表对象属于哪个模式

Q: 确定一个表属于哪个模式

A:

TEST=# \d

               关系列表

 Schema | Name | Type  | Owner  |  Size  

--------+------+-------+--------+---------

 PUBLIC | A    | table | SYSTEM | 0 bytes

 PUBLIC | DUAL | table | SYSTEM | 32 kB

(2 行)

TEST=# select * from sys_class where relname='A';

 RELNAME | RELNAMESPACE | RELTYPE | RELOWNER | RELAM | RELFILENODE | RELTABLESPACE | RELPAGES | RELALLVISIBLEPAGES | RELTUPLES | RELTOASTRELID | RELTOASTIDXID | RELHASINDEX | RELISCLUSTER | RELISSHARED | RELKIND | RELPARTTYP | RELNATTS | RELCHECKS | RELTRIGGERS | RELUKEYS | RELFKEYS | RELREFS | RELHASOIDS | RELHASPKEY | RELHASRULES | RELHASSUBCLASS | RELFROZENXID | RELBUFPOOLWAY | RELISTPL | RELISENCRYPTED | RELKEYID | RELPCOLOFF | RELPRELOID | RELACL | RELOPTIONS

---------+--------------+---------+----------+-------+-------------+---------------+----------+--------------------+-----------+---------------+---------------+-------------+--------------+-------------+---------+------------+----------+-----------+-------------+----------+----------+---------+------------+------------+-------------+----------------+--------------+---------------+----------+----------------+----------+------------+------------+--------+------------

 A       |         2200 | 5294504 |       10 |     0 |    23071168 |          1664 |        0 |                  0 |         0 |             0 |             0 | f           | f            | f           | r       | n          |        1 |         0 |           0 |        0 |        0 |       0 | f          | f          | f           | f              |    197475827 | n             | f        | n              |          |            |            |        |

(1 行)

TEST=# select oid,* from sys_namespace where oid='2200';

 OID  | NSPNAME | NSPOWNER | NSPPARENT |            NSPACL            

------+---------+----------+-----------+-------------------------------

 2200 | PUBLIC  |       10 |         0 | {SYSTEM=UC/SYSTEM,=UC/SYSTEM}

(1 行)