DB2查看表结构及所用表语句

DB2查看表结构及所用表语句

 

查看所用表（注：条件内容需要大写） 

  www.zzzyk.com  

Sql代码  

select * from sysibm.systables where type='T' and creator = 'FRONT'  

 

 

查看表字段（注：条件内容需要大写） 

  www.zzzyk.com  

Sql代码  

select * from sysibm.columns where table_schema = 'FRONT' and table_name = 'PRODUCT'