The BTYPE column identifies the object type: 'T' for table, 'I' for index, and 'F' for function instance.
BTYPE 列显示对象类型:'T' 表示表,'I' 表示索引,'F' 表示函数实例。
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)约束保持一个行db2 select constname, tabname, type from syscat . tabconst。
应用推荐