1 查看表
select distinct object_name(id) from syscomments
where id in ( select object_id from sys.objects where type = ' P ' )and text like '%tablename%'
2 查看存储过程
sp_depends 'name'
1 查看表
select distinct object_name(id) from syscomments
where id in ( select object_id from sys.objects where type = ' P ' )and text like '%tablename%'
2 查看存储过程
sp_depends 'name'