Show all columns name from object name

select l.name + ', '
from sysobjects s
inner join sys.schemas c on c.schema_id = s.uid
inner join syscolumns l on l.id = s.id
where s.name like '%object_name%'

Etiquetas: