Wednesday, 21 February 2018

MSSQL - List all stored procedures related to specified table


Watch on YouTube




Select sys.sysobjects.name, sys.sysobjects.xtype FROM

sys.syscomments inner join sys.sysobjects on sys.syscomments.id = sys.sysobjects.id
where sys.syscomments.text like '%TABLE_NAME%' and sys.sysobjects.xtype = 'P'

No comments:

Post a Comment