Return a list of tables with a matching column name

Sometimes reverse engineering a database requires searching for specific strings in all of the column names in all of the tables in the database. The following query will do such a search in Microsoft SQL Server.

SELECT
  COLUMN_NAME, TABLE_NAME 
FROM 
  INFORMATION_SCHEMA.COLUMNS 
WHERE 
  COLUMN_NAME LIKE '%searchString%'