Wednesday 4 September 2013

Get List of Stored Procedures Where a Table Name is Used in SQL Server


Following code will  get procedures name which contains particular table name

SELECT Name FROM sys.procedures WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%TableName%'

No comments:

Post a Comment