--IDENTIFICAÇÃO DE CONSTRAINTS FORA DO PADRÃO SYNCHROSELECT 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_%'
WHERE (CONSTRAINT_NAME LIKE 'BON%'
OR INDEX_NAME LIKE 'BON_%')
AND TABLE_NAME NOT LIKE 'BON_%'
--IDENTIFICAÇÃO DE ÍNDICES FORA DO PADRÃO SYNCHROSELECT * 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
WHERE A.INDEX_NAME LIKE 'BON_%'
AND A.TABLE_NAME NOT LIKE 'BON_%'
AND A.INDEX_NAME = B.INDEX_NAME
Nenhum comentário :
Postar um comentário