oracle 查询 主键列 & 唯一性约束列

1. oracle 查看指定表的主键的column_name

SELECT cols.column_name, cons.table_name
FROM all_constraints cons
JOIN all_cons_columns cols ON cons.constraint_name = cols.constraint_name
WHERE cons.table_name in (
'table_name1',
'table_name2',
'table_name3'
) AND cons.constraint_type = 'P';

2. oracle 查看指定表的唯一性约束的column_name

SELECT cols.column_name, cons.table_name
FROM all_constraints cons
JOIN all_cons_columns cols ON cons.constraint_name = cols.constraint_name
WHERE cons.table_name in (
'table_name1',
'table_name2',
'table_name3'
) AND cons.constraint_type = 'U';