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