Friday, March 15, 2013

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%'


No comments:

Post a Comment