如何判断某个字段是否为主键(50分)

B

bird007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-09

• #1

请问在oracle中如何判断某个字段是否为主键

 

S

SmallGhost

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-09

• #2

SELECT CONSTRAINT_NAME from USER_CONSTRAINTS WHERE TABLE_NAME = ''???'' and CONSTRAINT_TYPE = ''P''

 

B

bird007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-10

• #3

接受答案了.