La consulta es simple y se debe reemplazar “Nombre_de_mi_tabla” por el nombre a buscar.
SELECT
sysobjects.name AS table_name,
syscolumns.name AS column_name,
systypes.name AS datatype,
syscolumns.LENGTH AS LENGTH
FROM
sysobjects
INNER JOIN syscolumns ON sysobjects.id = syscolumns.id
INNER JOIN systypes ON syscolumns.xtype = systypes.xtype
WHERE
(sysobjects.xtype = 'U')
and (
UPPER(syscolumns.name) like upper('%Nombre_de_mi_tabla%')
)
ORDER BY
sysobjects.name,
syscolumns.colid
Espero que les sirva.