Integração Analytics

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;