Informix如何查看表的主键使用了哪些列?-灵析社区
MastFancy通过sysconstraints只能看到一个{tab_id}_{id}字符串. 无法确认这个主键用了哪些列
你可以的拿捏了写的不太好，欢迎高手指点
select c.colno,c.colname,sc.idxname FROM syscolumns c
join SYSCONSTRAINTS sc on sc.tabid = c.tabid
join (
select idxname,part1 as colno from SYSINDEXES si where tabid=107 and part1 >0
union all
select idxname,part2 as colno from SYSINDEXES si where tabid=107 and part2 >0
union all
select idxname,part3 as colno from SYSINDEXES si where tabid=107 and part3 >0
union all
select idxname,part4 as colno from SYSINDEXES si where tabid=107 and part4 >0
union all
select idxname,part5 as colno from SYSINDEXES si where tabid=107 and part5 >0
union all
select idxname,part6 as colno from SYSINDEXES si where tabid=107 and part6 >0
union all
select idxname,part7 as colno from SYSINDEXES si where tabid=107 and part7 >0
union all
select idxname,part8 as colno from SYSINDEXES si where tabid=107 and part8 >0
union all
select idxname,part9 as colno from SYSINDEXES si where tabid=107 and part9 >0
union all
select idxname,part10 as colno from SYSINDEXES si where tabid=107 and part10 >0
union all
select idxname,part11 as colno from SYSINDEXES si where tabid=107 and part11 >0
union all
select idxname,part12 as colno from SYSINDEXES si where tabid=107 and part12 >0
) as t on t.colno = c.colno and t.idxname =sc.idxname
where c.tabid=107 and sc.constrtype = 'P'