Identifiação de Constraints e Indices

--IDENTIFICAÇÃO DE CONSTRAINTS FORA DO PADRÃO SYNCHRO SELECT DISTINCT TABLE_NAME, CONSTRAINT_NAME, INDEX_NAME  FROM USER_CONSTRAINTS WHERE (CONSTRAINT_NAME LIKE 'BON%' OR INDEX_NAME LIKE 'BON_%') AND TABLE_NAME NOT LIKE 'BON_%' --IDENTIFICAÇÃO DE ÍNDICES FORA DO PADRÃO SYNCHRO SELECT * FROM User_Ind_Columns where index_name = 'BON_LFIS_IDF_IMPOSTO_UK' SELECT A.TABLE_NAME, A.INDEX_NAME, A.COLUMN_NAME, B.UNIQUENESS FROM  USER_IND_COLUMNS A , USER_INDEXES B WHERE A.INDEX_NAME LIKE 'BON_%' AND A.TABLE_NAME NOT LIKE 'BON_%' AND A.INDEX_NAME = B.INDEX_NAME