如何能看到一个已建好的表的主键

Question

select * from user_constraints
where table_name = 'tbname'
and constraint_type ='P';

Answer 1

select CONSTRAINT_NAME,CONSTRAINT_TYPE,TABLE_NAME from user_constraints WHERE CONSTRAINT_TYPE='P'

Answer 2

用pl/sql edit或view 也可以

Answer 3

SELECT "DBA_CONS_COLUMNS"."OWNER",   
         "DBA_CONS_COLUMNS"."CONSTRAINT_NAME",   
         "DBA_CONS_COLUMNS"."TABLE_NAME",   
         "DBA_CONSTRAINTS"."CONSTRAINT_TYPE"  
    FROM "DBA_CONS_COLUMNS",   
         "DBA_CONSTRAINTS"  
   WHERE ( "DBA_CONS_COLUMNS"."OWNER" = "DBA_CONSTRAINTS"."OWNER" ) and  
         ( "DBA_CONS_COLUMNS"."CONSTRAINT_NAME" = "DBA_CONSTRAINTS"."CONSTRAINT_NAME" ) and  
         ("DBA_CONS_COLUMNS"."OWNER" = :Owner AND  
         "DBA_CONS_COLUMNS"."TABLE_NAME" = :TableName) AND  
         "DBA_CONSTRAINTS"."CONSTRAINT_TYPE" = 'P'