SQL Server : Query Definition of an Object

— Another way to query the definition of an object:

SELECT OBJECT_NAME(object_id), *

FROM sys.sql_modules

WHERE LOWER(DEFINITION) LIKE ‘%tbl%’