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