Sqls para auxilar na tarefa encontrar campos em um banco dadaos desconhecido.



----Sql SERVER
SELECT
    T.name AS Tabela,
    C.name AS Coluna
FROM
    sys.sysobjects    AS T (NOLOCK)
INNER JOIN sys.all_columns AS C (NOLOCK) ON T.id = C.object_id AND T.XTYPE = 'U'
WHERE
    C.NAME LIKE '%NomeDoCampo%'
ORDER BY
    T.name ASC


----Postgress

SELECT *
FROM information_schema.columns 
where information_schema.columns.column_name  = 'referencia'



-----Oracle

SELECT  *  
FROM
    USER_TABLES TABELA,
    USER_TAB_COLUMNS COLUNAS
WHERE
    -- JOINS
    TABELA.TABLE_NAME = COLUNAS.TABLE_NAME
    AND COLUNAS.COLUMN_NAME LIKE '%ESTADUAL%'


-----fireBird

select rdb$relation_name, rdb$field_name
from rdb$relation_fields
order by rdb$relation_name, rdb$field_name;