The TABNAME column lists the names of the MQTs, and the BNAME column lists the names of the database objects on which the corresponding MQTs depend.
TABNAME列列出MQT的名称,BNAME 列列出相应的 MQT所依赖的数据库对象的名称。
Syscat.constdep Contains a row for each dependency of a constraint on some other object db2 select constname, tabname, btype, bname from syscat.constdep.
constdep为其他对象上约束的每个依赖项保持一个行db2select constname,tabname,btype,bname from syscat . constdep。
Syscat.constdep Contains a row for each dependency of a constraint on some other object db2 select constname, tabname, btype, bname from syscat.constdep.
constdep为其他对象上约束的每个依赖项保持一个行db2select constname,tabname,btype,bname from syscat . constdep。
应用推荐