Skip to content

Instantly share code, notes, and snippets.

@freemanirl

freemanirl/find-col-references.sql

Created February 12, 2020 20:35
Show Gist options
  • Save freemanirl/756dcad32fc9a14145aaa367ddae5c4c to your computer and use it in GitHub Desktop.
Save freemanirl/756dcad32fc9a14145aaa367ddae5c4c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
find-col-references.sql
DECLARE @ColName [varchar](32) = 'EntitledMinutes'
SELECT sys.objects.object_id, sys.schemas.name AS [Schema], sys.objects.name AS Object_Name, sys.objects.type_desc AS [Type]
FROM sys.sql_modules (NOLOCK)
INNER JOIN sys.objects (NOLOCK) ON sys.sql_modules.object_id = sys.objects.object_id
INNER JOIN sys.schemas (NOLOCK) ON sys.objects.schema_id = sys.schemas.schema_id
WHERE
sys.sql_modules.definition COLLATE SQL_Latin1_General_CP1_CI_AS LIKE '%' + @ColName + '%' ESCAPE '\'
ORDER BY sys.objects.type_desc, sys.schemas.name, sys.objects.name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment