表的主码信息在oracle8那张表中能找到?

[wangkeping]

表的主码信息在oracle8那张表中能找到?

[suo]

什么是主码信息?是不是要ID?dba_objects中有

[penitent]

主键吧，在user_tab_columns表中有

[zcs_1]

SELECT column_name FROM user_cons_columns
WHERE constraint_name = (SELECT constraint_name
FROM user_constraints
WHERE table_name=TNAME
AND constraint_type='P')

[black_dragon]

SELECT s.constraint_name,t.column_name FROM user_con_columns t,user_constrains s
WHERE s.table_name='TNAME'
AND s.constraint_type='P'
AND t.constraint_name=s.constraint_name
ORDER BY t.position;

[jlandzpa]

同意 zcs_1(生生不息)

[bluecetacean]

上面的语句执行有误
ERROR 位于第 1 行:
ORA-00942: 表或视图不存在

[black_dragon]

sorry,写错了
SELECT s.constraint_name,t.column_name FROM user_cons_columns t,user_constraints s
WHERE s.table_name='TNAME'
AND s.constraint_type='P'
AND t.constraint_name=s.constraint_name
ORDER BY t.position;