Syscat.checks Contains a row for each table check constraint db2 select constname, tabname, text from syscat.checks.
checks为每个表检查约束保持一个行db2select constname,tabname,textfrom 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为其他对象上约束的每个依赖项保持一个行db2select 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为表检查约束所引用的每个列保持一个行db2select constname,tabname,colname,usage from syscat.colchecks
Syscat.tabconst Contains a row for each unique (u), primary key (p), foreign key (f), or table check (k) constraint db2 select constname, tabname, type from syscat.tabconst.
tabconst为每个唯一性(U)、主键(p)、外键(f)或者表检查(K)约束保持一个行db2select constname,tabname,typefrom syscat . tabconst。
Syscat.references Contains a row for each referential constraint db2 select constname, tabname, refkeyname, reftabname, colcount, deleterule, updaterule from syscat.references.
references为每个参照约束保持一个行db2select constname,tabname,refkeyname,reftabname,colcount,deleterule,updaterule from syscat . references。
Syscat.references Contains a row for each referential constraint db2 select constname, tabname, refkeyname, reftabname, colcount, deleterule, updaterule from syscat.references.
references为每个参照约束保持一个行db2select constname,tabname,refkeyname,reftabname,colcount,deleterule,updaterule from syscat . references。
应用推荐