- 查询某个表被哪些存储过程使用到 :
SELECT DISTINCT OBJECT_NAME(id) FROM syscomments WHERE EXISTS ( SELECT 1 FROM sys.objects WHERE type = 'P' AND object_id = id ) AND text LIKE '%TableName%'
- 查找那些过程对该表做了更新操作:
SELECT DISTINCT OBJECT_NAME(id) FROM syscomments WHERE EXISTS ( SELECT 1 FROM sys.objects WHERE type = 'P' AND object_id = id ) AND text LIKE '%update TableName%'
MSSQL查询某个表在哪些存储过程中使用过
最新推荐文章于 2024-04-18 09:41:10 发布