db2查看当前模式的sql
通过DB2提供的专用寄存器current schema/sqlid可以查看当前的模式,比如select current schema from sysibm.sysdummy1
select current schema from sysibm.dual
或
select current sqlid from sysibm.sysdummy1
select current sqlid from sysibm.dual
或
values current schema
注:dual是一个从sysdummy1中创建而来的view
--查看sysibm和syscat模式下的表
db2 list tables for schema sysibm
db2 list tables for schema syscat
页:
[1]