Syscat.checks Contains a row for each table check constraint db2 select constname, tabname, text from syscat.checks.
checks为每个表检查约束保持一个行db2 select constname, tabname, text from syscat . checks。
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为其他对象上约束的每个依赖项保持一个行db2 select constname, tabname, btype, bname from syscat . constdep。
SYSCAT.COLCHECKS Contains a row for each column that is referenced by a table check constraint db2 select constname, tabname, colname, usage from syscat.colchecks
COLCHECKS 为表检查约束所引用的每个列保持一个行 db2 select constname, tabname, colname, usage from syscat.colchecks
应用推荐