quarta-feira, 24 de julho de 2019

Busca Dentro do SQL



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 '%ELEMENTO%'
ORDER BY
    T.name ASC

Nenhum comentário: