sql查询表在那个存储过程中使用

select name from sys.objects where object_id in (select id from syscomments where text like '%tablename%')