Skip to content

Instantly share code, notes, and snippets.

@pwiesner

pwiesner/find_column.sql

Last active December 26, 2015 09:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pwiesner/7126789 to your computer and use it in GitHub Desktop.
Save pwiesner/7126789 to your computer and use it in GitHub Desktop.
Download ZIP
Search SqlServer for a column with a specific name
Raw
find_column.sql
--BEGIN
SELECT
SCHEMA_NAME(schema_id) AS schema_name,
t.name AS table_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 '%SEARCH%'
ORDER BY
schema_name, table_name;
--END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment