Buscar Campo no SQL Server

CREATE  PROCEDURE buscarCampo(@campo text)
AS
BEGIN
    SELECT tb.name AS Nome_da_Tabela,
        SCHEMA_NAME(schema_id) AS schema_nome,
        c.name AS Nome_da_Coluna
    FROM sys.TABLES AS tb
        INNER JOIN sys.COLUMNS c ON tb.object_id = c.object_id
    WHERE c.name LIKE @campo
    ORDER BY schema_name, Nome_da_Tabela
END