查看所用表(注:条件内容需要大写)
[img]http://dl.iteye.com/upload/attachment/0074/0786/11af1c6f-8112-3e21-a479-c608404abf74.jpg[/img]
查看表字段(注:条件内容需要大写)
[img]http://dl.iteye.com/upload/attachment/0074/0788/8437ea24-2f5e-3b9d-9979-2c5e2eee83a2.jpg[/img]
select * from sysibm.systables where type='T' and creator = 'FRONT'
[img]http://dl.iteye.com/upload/attachment/0074/0786/11af1c6f-8112-3e21-a479-c608404abf74.jpg[/img]
查看表字段(注:条件内容需要大写)
select * from sysibm.columns where table_schema = 'FRONT' and table_name = 'PRODUCT'
[img]http://dl.iteye.com/upload/attachment/0074/0788/8437ea24-2f5e-3b9d-9979-2c5e2eee83a2.jpg[/img]