模式-SYS_SCHEMAS
📄字数 503
👁️阅读量 加载中...
功能描述
SYS_SCHEMAS系统表用于管理数据库模式相关信息。
字段说明
| 序号 | 字段名 | 类型 | 说明 | V11 | V12 |
|---|---|---|---|---|---|
| 0 | DB_ID | INTEGER | 库ID | √ | √ |
| 1 | SCHEMA_ID | INTEGER | 模式ID | √ | √ |
| 2 | USER_ID | INTEGER | 属主的用户ID | √ | √ |
| 3 | SCHEMA_NAME | VARCHAR | 模式名 | √ | √ |
| 4 | COMMENTS | VARCHAR | 注释信息 | √ | √ |
| 5 | IS_SYS | BOOLEAN | 是否系统内建 | √ | √ |
| 6 | REG_MODIFY | BOOLEAN | 是否记载变更日志 | √ | √ |
| 7 | STO_ZONE | INTEGER | 存储域 | x | √ |
| 8 | RESERVED2 | VARCHAR | 保留字段 | √ | √ |
| 9 | RESERVED3 | VARCHAR | 保留字段 | √ | √ |
应用举例
- 查询用户所属模式
sql
-- 创建用户所属模式
SQL> CREATE SCHEMA schema_info AUTHORIZATION SYSDBA;
SQL> SELECT * FROM SYS_SCHEMAS;
+-------+-----------+---------+-------------+----------+--------+------------+----------+-----------+-----------+
| DB_ID | SCHEMA_ID | USER_ID | SCHEMA_NAME | COMMENTS | IS_SYS | REG_MODIFY | STO_ZONE | RESERVED2 | RESERVED3 |
+-------+-----------+---------+-------------+----------+--------+------------+----------+-----------+-----------+
| 1 | 1 | 1 | SYSDBA | <NULL> | T | <NULL> | 0 | <NULL> | <NULL> |
| 1 | 2 | 2 | SYSSSO | <NULL> | T | <NULL> | 0 | <NULL> | <NULL> |
| 1 | 3 | 3 | SYSAUDITOR | <NULL> | T | <NULL> | 0 | <NULL> | <NULL> |
| 1 | 4 | 4 | GUEST | <NULL> | T | <NULL> | 0 | <NULL> | <NULL> |
| 1 | 101 | 1 | SCHEMA_INFO | <NULL> | F | <NULL> | 0 | <NULL> | <NULL> |
+-------+-----------+---------+-------------+----------+--------+------------+----------+-----------+-----------+