Skip to content

Instantly share code, notes, and snippets.

@ststeiger

ststeiger/Check_Column_Usage.sql

Created February 19, 2016 14:58
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ststeiger/862cf010d59417bb26b6 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ststeiger/862cf010d59417bb26b6 to your computer and use it in GitHub Desktop.
Download ZIP
Check if a column is used in a view, procedure, scalar or table-valued function
Raw
Check_Column_Usage.sql
;WITH CTE AS (
SELECT table_name AS obj_name, OBJECT_DEFINITION(OBJECT_ID(table_name)) AS obj_def FROM INFORMATION_SCHEMA.VIEWS
UNION ALL SELECT specific_name AS obj_name , OBJECT_DEFINITION(OBJECT_ID(specific_name)) AS obj_def FROM INFORMATION_SCHEMA.ROUTINES
)
SELECT * FROM CTE
WHERE (1=2)
OR obj_def LIKE '%AutoNr%'
OR obj_def LIKE '%copyView%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment