[MSSQL] 특정 프로시저에서 사용중인 테이블 목록 조회

 

select distinct 
       b.name as proc_name,
       c.name as table_name
  from sysdepends a
  left join sysobjects b on b.id = a.id 
  left join sysobjects c on c.id = a.depid
 where 1=1
   and b.xtype = 'P' 
   and b.name = '[프로시저명]'