January 19, 2017

Get list of tables used in Stored procedure


SELECT DISTINCT        so.ID, so.name AS 'Procedure Name' , oo.name AS 'Table Name'
FROM sysdepends d, sysobjects so, sysobjects oo
WHERE    so.id=d.id
      AND so.name= 'Stored_Proc_Name'   -- Enter Your stored Procedure Name here
      AND oo.id=d.depid
ORDER BY so.NAME,oo.NAME


No comments:

Post a Comment