document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. CREATE  PROCEDURE buscarCampo(@campo text)
  2. AS
  3. BEGIN
  4.     SELECT tb.name AS Nome_da_Tabela,
  5.         SCHEMA_NAME(schema_id) AS schema_nome,
  6.         c.name AS Nome_da_Coluna
  7.     FROM sys.TABLES AS tb
  8.         INNER JOIN sys.COLUMNS c ON tb.object_id = c.object_id
  9.     WHERE c.name LIKE @campo
  10.     ORDER BY schema_name, Nome_da_Tabela
  11. END
');