Column Name Search

An extension of Table/View Column Information

In the event that you need to find a table that has a specific column name.

SELECT
	t.name AS table_name,
	SCHEMA_NAME(schema_id) AS schema_name,
	c.name AS column_name
FROM
	sys.tables AS t
	INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE
	c.name LIKE '%requestNumber%'
ORDER BY
	schema_name,
	table_name;