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