DB2查看表結構及所用表語句
查看所用表(注:條件內容需要大寫)
www.2cto.com
Sql代碼
select * from sysibm.systables where type='T' and creator = 'FRONT'
查看表字段(注:條件內容需要大寫)
www.2cto.com
Sql代碼
select * from sysibm.columns where table_schema = 'FRONT' and table_name = 'PRODUCT'