Skip to Content
0
Jul 26 at 06:51 PM

List of tables used inside stored procedure

98 Views

Hi Friends,

I want to know the easiest way to list down the number of tables used inside any stored procedure. This is to make sure all the table names are replaced with XSA synonyms. I checked OBJECT_DEPENDENCIES view but it does not contain procedure level object dependencies.

Thanks,

Gaurav