日期:2014-05-16  浏览次数:20555 次

DB2 查看表结构,DB2查看所用表
查看所用表(注:条件内容需要大写)
select * from sysibm.systables where type='T' and creator = 'FRONT'




查看表字段(注:条件内容需要大写)
select * from sysibm.columns where table_schema = 'FRONT' and table_name = 'PRODUCT'