Skip to content

Instantly share code, notes, and snippets.

@jacobhackl

jacobhackl/gist:6922bcde095d147d2fe5

Created November 20, 2014 23:01
Show Gist options
  • Save jacobhackl/6922bcde095d147d2fe5 to your computer and use it in GitHub Desktop.
Save jacobhackl/6922bcde095d147d2fe5 to your computer and use it in GitHub Desktop.
Download ZIP
Search SQL objects for a column
Raw
gistfile1.txt
-- Search in All Objects
SELECT OBJECT_NAME(OBJECT_ID),
definition
FROM sys.sql_modules
WHERE definition LIKE '%' + 'CreatedDate' + '%'
GO
-- Search in Stored Procedure Only
SELECT DISTINCT OBJECT_NAME(OBJECT_ID),
object_definition(OBJECT_ID)
FROM sys.Procedures
WHERE object_definition(OBJECT_ID) LIKE '%' + 'CreatedDate' + '%'
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment