二、 oracle获取主键,索引,元信息
1.primary key和unique
select c.owner,c.table_name,c.column_name,a.constraint_type
from all_constraints a,all_cons_columns c
where a.constraint_name=c.constraint_name and a.owner=c.owner and (a
select c.owner,c.table_name,c.column_name,a.constraint_type
from all_constraints a,all_cons_columns c
where a.constraint_name=c.constraint_name and a.owner=c.owner and (a