互联网服务查询表GBase 8t

Gbase8t查询表主键的疑问?

怎么查询表的主键是哪几列显示全部

怎么查询表的主键是哪几列

收起
参与3

返回GBase_David的回答

GBase_DavidGBase_David  DBA , GBase

select
o.constrname,
i.idxname,
t.tabname,
(select c1.colname from syscolumns c1 where c1.colno=abs(i.part1) and o.tabid=c1.tabid) ||
nvl(','||(select c1.colname from syscolumns c1 where c1.colno=abs(i.part2 ) and o.tabid=c1.tabid),'')||
nvl(','||(select c1.colname from syscolumns c1 where c1.colno=abs(i.part3 ) and o.tabid=c1.tabid),'')||
nvl(','||(select c1.colname from syscolumns c1 where c1.colno=abs(i.part4 ) and o.tabid=c1.tabid),'')||
nvl(','||(select c1.colname from syscolumns c1 where c1.colno=abs(i.part5 ) and o.tabid=c1.tabid),'')||
nvl(','||(select c1.colname from syscolumns c1 where c1.colno=abs(i.part6 ) and o.tabid=c1.tabid),'')||
nvl(','||(select c1.colname from syscolumns c1 where c1.colno=abs(i.part7 ) and o.tabid=c1.tabid),'')||
nvl(','||(select c1.colname from syscolumns c1 where c1.colno=abs(i.part8 ) and o.tabid=c1.tabid),'')||
nvl(','||(select c1.colname from syscolumns c1 where c1.colno=abs(i.part9 ) and o.tabid=c1.tabid),'')||
nvl(','||(select c1.colname from syscolumns c1 where c1.colno=abs(i.part10) and o.tabid=c1.tabid),'')||
nvl(','||(select c1.colname from syscolumns c1 where c1.colno=abs(i.part11) and o.tabid=c1.tabid),'')||
nvl(','||(select c1.colname from syscolumns c1 where c1.colno=abs(i.part12) and o.tabid=c1.tabid),'')||
nvl(','||(select c1.colname from syscolumns c1 where c1.colno=abs(i.part13) and o.tabid=c1.tabid),'')||
nvl(','||(select c1.colname from syscolumns c1 where c1.colno=abs(i.part14) and o.tabid=c1.tabid),'')||
nvl(','||(select c1.colname from syscolumns c1 where c1.colno=abs(i.part15) and o.tabid=c1.tabid),'')||
nvl(','||(select c1.colname from syscolumns c1 where c1.colno=abs(i.part16) and o.tabid=c1.tabid),'') collist
from sysconstraints o,sysindexes i,systables t
where o.constrtype='P'
and o.idxname=i.idxname
and o.tabid=t.tabid
and t.tabname='table_name';

IT其它 · 2019-04-24
浏览2439

回答者

GBase_David 最近回答过的问题

回答状态

  • 发布时间:2019-04-24
  • 关注会员:2 人
  • 回答浏览:2439
  • X社区推广