系统视图集合-SYS_SYSTEM_VIEWS

📄字数 656

👁️阅读量 加载中...

功能描述

SYS_SYSTEM_VIEWS系统表用于管理所有系统视图集合信息。

字段说明

序号	字段名	类型	说明	V11	V12
0	DB_ID	INTEGER	库ID	√	√
1	SCHEMA_ID	INTEGER	模式ID	√	√
2	USER_ID	INTEGER	属主ID	√	√
3	VIEW_ID	INTEGER	视图ID	√	√
4	VIEW_NAME	VARCHAR	视图名	√	√
5	DEFINE	VARCHAR	视图定义	√	√
6	OPTION	INTEGER	0：无 1：with read only 2：with check option	√	√
7	CREATE_TIME	DATETIME	创建时间	√	√
8	VALID	BOOLEAN	是否有效	√	√
9	IS_SYS	BOOLEAN	是否系统内建	√	√
10	COMMENTS	VARCHAR	注释信息	√	√
11	RESERVED1	VARCHAR	保留字段	√	√
12	RESERVED2	VARCHAR	保留字段	√	√

注意

该虚表内容无法人为修改

应用举例

• 通过系统表查询是否有对应系统视图

SQL> SELECT * FROM SYS_SYSTEM_VIEWS WHERE view_name='ALL_DATABASES';
+--------+-----------+---------+---------+---------------+---------------------------------------------------------------------------------------------------------------+--------+--------------------------+-------+--------+----------+-----------+-----------+
| DB_ID  | SCHEMA_ID | USER_ID | VIEW_ID |   VIEW_NAME   |                                                    DEFINE                                                     | OPTION |       CREATE_TIME        | VALID | IS_SYS | COMMENTS | RESERVED1 | RESERVED2 |
+--------+-----------+---------+---------+---------------+---------------------------------------------------------------------------------------------------------------+--------+--------------------------+-------+--------+----------+-----------+-----------+
| <NULL> | 1         | 1       | 76      | ALL_DATABASES | CREATE VIEW ALL_DATABASES AS SELECT * FROM SYS_DATABASES WHERE USER_ID=CURRENT_USERID OR DB_ID=CURRENT_DB_ID; | 0      | 2025-07-10 19:44:36.903  | T     | <NULL> | <NULL>   | <NULL>    | <NULL>    |
+--------+-----------+---------+---------+---------------+---------------------------------------------------------------------------------------------------------------+--------+--------------------------+-------+--------+----------+-----------+-----------+