Look for DB objects with some text in them

SQL Server object lookup by text

DECLARE @textToLookFor VARCHAR(200)
 
SET @textToLookFor = 'InventoryTransaction'
 
SELECT * FROM INFORMATION_SCHEMA.ROUTINES
WHERE OBJECT_DEFINITION(OBJECT_ID(ROUTINE_SCHEMA + '.' + ROUTINE_NAME)) LIKE '%' + @textToLookFor + '%'

SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE OBJECT_DEFINITION(OBJECT_ID(TABLE_SCHEMA + '.' + TABLE_NAME)) LIKE '%' + @textToLookFor + '%'

SELECT * FROM INFORMATION_SCHEMA.VIEWS
WHERE OBJECT_DEFINITION(OBJECT_ID(TABLE_SCHEMA + '.' + TABLE_NAME)) LIKE '%' + @textToLookFor + '%'