db2 查新索引 主键 sql

1.查询主键

select * from sysibm.syskeycoluse where tbname='...'

 

2.查询索引

select * from sysibm.indexs where tbname='...'