小崔说SAP技术博客 - 表名
type: channel
link: https://sapxiaocui.top/index.php/tag/%E8%A1%A8%E5%90%8D/
items: SQL 查询某个表在哪些存储过程（SP）中被使用到
items: SQL 查找某个字段在哪些表存在查询语句

SQL 查询某个表在哪些存储过程（SP）中被使用到
type: item
date: 2023-08-07T07:06:00+00:00
description: 1.查询某个表被哪些存储过程(以下简称 SP)使用 :select distinct object_name(id) from syscomments where id in(select object_id from sys.objects where type='P') and text like'%TableName%'2.查找那些过程对该表做了更新操作：select distinct object_name(id) from syscomments where id in(select object_id from sys.objects where type='P') and text like'%update tablename%'3.查询当前数据库中所有SP：select name as 存储过程 from sysobjects where type = 'P'

SQL 查找某个字段在哪些表存在查询语句
type: item
date: 2023-04-15T09:42:00+00:00
description: SELECT a.*,b.IS_IDENTITY FROM INFORMATION_SCHEMA.COLUMNS a JOIN sys.columns b on a.COLUMN_NAME = 你需要查询的字段