select * from user_indexes t where t.table_name=upper('');
--查看表的主键 select * from user_constraints where table_name='' and constraint_type='P';--查看表的索引 select * from user_indexes where table_name='';
select dis.index_name,dcs.constraint_name from dba_constraints dcs, dba_indexes dis where dcs.table_name = 'CCODE' and dcs.owner='BMS' and dcs.table_name = dis.table_name and dcs.owner = dis.owner
1 依据表名 求主键字段 select b.table_name, b.column_name from user_constraints a, user_cons_columns b where a.table_name = 'YW_DYYWB' and a.constraint_type = 'P' and a.constraint_name = b.constraint_name
shit 楼主是要索引主键的名称 还是相应字段啊
SELECT a.table_name, a.index_name, decode(c.uniqueness || b.nullable, 'UNIQUEN', 'PRIMARY KEY', c.uniqueness || ' INDEX'), wm_concat(a.column_name) FROM user_ind_columns a, user_tab_cols b, user_indexes c WHERE a.table_name = b.table_name AND a.column_name = b.column_name AND a.index_name = c.index_name AND a.table_name = c.table_name GROUP BY a.table_name, a.index_name, decode(c.uniqueness || b.nullable, 'UNIQUEN', 'PRIMARY KEY', c.uniqueness || ' INDEX');
哈,忘记加上筛选条件了 SELECT a.table_name, a.index_name, decode(c.uniqueness || b.nullable, 'UNIQUEN', 'PRIMARY KEY', c.uniqueness || ' INDEX'), wm_concat(a.column_name) FROM user_ind_columns a, user_tab_cols b, user_indexes c WHERE a.table_name = b.table_name AND a.column_name = b.column_name AND a.index_name = c.index_name AND a.table_name = c.table_name and a.table_name=upper('') GROUP BY a.table_name, a.index_name, decode(c.uniqueness || b.nullable, 'UNIQUEN', 'PRIMARY KEY', c.uniqueness || ' INDEX');
select *
from user_constraints
where table_name='' and constraint_type='P';--查看表的索引
select *
from user_indexes
where table_name='';
where dcs.table_name = 'CCODE' and dcs.owner='BMS' and dcs.table_name = dis.table_name
and dcs.owner = dis.owner
select b.table_name, b.column_name
from user_constraints a, user_cons_columns b
where a.table_name = 'YW_DYYWB'
and a.constraint_type = 'P'
and a.constraint_name = b.constraint_name
a.index_name,
decode(c.uniqueness || b.nullable,
'UNIQUEN',
'PRIMARY KEY',
c.uniqueness || ' INDEX'),
wm_concat(a.column_name)
FROM user_ind_columns a, user_tab_cols b, user_indexes c
WHERE a.table_name = b.table_name
AND a.column_name = b.column_name
AND a.index_name = c.index_name
AND a.table_name = c.table_name
GROUP BY a.table_name,
a.index_name,
decode(c.uniqueness || b.nullable,
'UNIQUEN',
'PRIMARY KEY',
c.uniqueness || ' INDEX');
SELECT a.table_name,
a.index_name,
decode(c.uniqueness || b.nullable,
'UNIQUEN',
'PRIMARY KEY',
c.uniqueness || ' INDEX'),
wm_concat(a.column_name)
FROM user_ind_columns a, user_tab_cols b, user_indexes c
WHERE a.table_name = b.table_name
AND a.column_name = b.column_name
AND a.index_name = c.index_name
AND a.table_name = c.table_name
and a.table_name=upper('')
GROUP BY a.table_name,
a.index_name,
decode(c.uniqueness || b.nullable,
'UNIQUEN',
'PRIMARY KEY',
c.uniqueness || ' INDEX');