Script SQL para localizar a tabela(s) que possui um determinado atributo (ou parte dele).
Declare @Atributo varchar(30)
Select @Atributo = ‘nr_ct‘ –INCLUIR AQUI o nome da coluna (ou parte dele)
Select @Atributo = ‘%’ + @Atributo + ‘%’
Select o.name as Tabela
from syscolumns c, sysobjects o
where c.id = o.id and
o.type = ‘U’and
c.name like @Atributo
Select o.name as Tabela
from syscolumns c, sysobjects o
where c.id = o.id and
o.type = ‘U’and
c.name like @Atributo
Alessandrovs
Compartilhe: