目录:
1.显式建立schema
2.隐式建立schema
3.查询现有的schema
4.删除schema
1.显式建立schema
执行create schema需要有DBADM权限
建立某个schema需要有SYSADM 和DBAMIN权限
总的来说就是需要SYSADM 和DBAMIN权限
Sql代码
--语法
CREATE SCHEMA <name>
AUTHORIZATION <
class="keyword">name>
--如果不输入AUTHORIZATION,就是执行命令的本人
db2 => create schema db2user12
DB20000I The SQL command completed successfully.
db2 => select SCHEMANAME,OWNER
from syscat.schemata where schemaname='DB2USER12'
SCHEMANAME OWNER
------------------------------
-----------
DB2USER12 DB2INST1
1 record(s) selected.
--语法
CREATE SCHEMA AUTHORIZATION
--如果不输入AUTHORIZATION,就是执行命令的本人
db2 => create schema db2user12
DB20000I The SQL command completed successfully.
db2 => select SCHEMANAME,OWNER from syscat.schemata where schemaname='DB2USER12'
SCHEMANAME OWNER
------------------------------ -----------
DB2USER12 DB2INST1
1 record(s) selected.
2.隐式建立schema
如果你没有SYSADM,DBADMIN权限,但是你有IMPLICIT_SCHEMA,那么你也可以建立schema
Sql代码