Skip to main content

T SQL : Listing of all sql object that uses a certain field name

SELECT
 [Object Name] = OBJECT_NAME(OBJECT_ID),
 [Object Content definition] = definition
FROM sys.sql_modules
WHERE definition LIKE '%' + 'FieldNameYouAreLookingFor' + '%'

Comments