@manhnguyenv

Welcome to my blog!

List Of Tables Used In Stored Procedure

April 21, 2020 10:14

List Of Tables Used In Stored Procedure (edit)

https://www.c-sharpcorner.com/blogs/find-list-of-tables-used-in-stored-procedure-using-types-of-joins

SELECT 
NAME as 'List Of Tables'
FROM SYSOBJECTS
WHERE ID IN ( SELECT SD.DEPID
FROM SYSOBJECTS SO,
SYSDEPENDS SD
WHERE SO.NAME = 'Sp_ListTables' ----name of stored procedures
AND SD.ID = SO.ID
)

Categories

Recent posts