[Resolvido] Localiza campo em tabelas

[advaldomesquita 93]

DECLARE @column        sysname
SET @column = '%LOJA_ID%'

SELECT a.name AS COLUNA, b.name AS TABELA
FROM dbo.syscolumns a JOIN dbo.sysobjects b ON a.id = b.id
WHERE a.name LIKE @column
AND b.xtype = 'U'
ORDER BY tabela

 

Abçs

 

A.Jr