Índice – Chave Primária

[fsitjaParticipante]

Dá para buscar na DBA_CONSTRAINTS com join na DBA_INDEXES (ou na ALL_ ou USER_ indexes e constraints, dependendo do seu privilégio e do requisito da busca).

---


select c.owner, i.table_name, c.constraint_name, i.index_name
from user_constraints c
join user_indexes i on c.index_owner = i.table_owner
and i.index_name = c.index_name
and i.table_name = c.table_name
where c.constraint_type = 'P'
and c.table_name = :minha_tab