Búsqueda de una columna en todas las tablas de una base de datos

sql-server-busqueda-columna.sql

USE <BASE_DATOS>
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_COLUMNA>%')
    )
ORDER BY
    sysobjects.name,
    syscolumns.colid