以下内容出自cookbook
/*列出模式中的表*/
select tabnamefrom syscat.tables
where tabschema = 'SMEAGOL'
/*列出表的列*/
select colname, typename, colno
from syscat.columns
where tabname = 'EMP'
and tabschema = 'SMEAGOL'
/*列出表的索引列*/
select a.tabname, b.indname, b.colname, b.colseq
from syscat.indexes a,
syscat.indexcoluse b
where a.tabname = 'EMP'
and a.tabschema = 'SMEAGOL'
and a.indschema = b.indschema
and a.indname = b.indname
/*列出表约束*/
select a.tabname, a.constname, b.colname, a.type
from syscat.tabconst a,
syscat.columns b
where a.tabname = 'EMP'
and a.tabschema = 'SMEAGOL'
and a.tabname = b.tabname
and a.tabschema = b.tabschema
/*列出没有相应索引的外键*/
select fkeys.tabname,
fkeys.constname,
fkeys.colname,
ind_cols.indname
from (
select a.tabschema, a.tabname, a.constname, b.colname
from syscat.tabconst a,
syscat.keycoluse b
where a.tabname = 'EMP'
and a.tabschema = 'SMEAGOL'
and a.type = 'F'
and a.tabname = b.tabname
and a.tabschema = b.tabschema
) fkeys
left join
(
select a.tabschema,
a.tabname,
a.indname,
b.colname
from syscat.indexes a,
syscat.indexcoluse b
where a.indschema = b.indschema
and a.indname = b.indname
) ind_cols
on ( fkeys.tabschema = ind_cols.tabschema
and fkeys.tabname = ind_cols.tabname
and fkeys.colname = ind_cols.colname )
where ind_cols.indname is null