select m.table_name,m.column_name,n.constraint_type from user_cons_columns m,user_constraints n where m.constraint_name=n.constraint_name and n.constraint_type = 'P'
向楼上两位学习。SELECT m.table_name,m.column_name,n.constraint_type FROM user_cons_columns m,user_constraints n WHERE m.constraint_name=n.constraint_name AND n.constraint_type = 'P' AND n.table_name = UPPER('your table name')
oracle的字典表的确比sqlserver的人性化多了.
select a.OWNER 用户名, a.CONSTRAINT_NAME 约束名称, a.CONSTRAINT_TYPE 约束类型, a.TABLE_NAME 表名, b.COLUMN_NAME 列名, a.SEARCH_CONDITION 约束内容 from USER_CONSTRAINTS a, USER_CONS_COLUMNS b where a.table_name = '表名' and a.CONSTRAINT_TYPE = 'P' -- and a.table_name = b.table_name and a.constraint_name = b.constraint_name
WHERE table_name = UPPER('table_name')
AND constraint_type = 'P'
from user_cons_columns m,user_constraints n
where m.constraint_name=n.constraint_name
and n.constraint_type = 'P'
FROM user_cons_columns m,user_constraints n
WHERE m.constraint_name=n.constraint_name
AND n.constraint_type = 'P'
AND n.table_name = UPPER('your table name')
a.CONSTRAINT_NAME 约束名称,
a.CONSTRAINT_TYPE 约束类型,
a.TABLE_NAME 表名,
b.COLUMN_NAME 列名,
a.SEARCH_CONDITION 约束内容
from USER_CONSTRAINTS a, USER_CONS_COLUMNS b
where a.table_name = '表名'
and a.CONSTRAINT_TYPE = 'P'
-- and a.table_name = b.table_name
and a.constraint_name = b.constraint_name