how to get the list of tables used in a storedprocedure

shivakrishna

how to get the list of all tables and views used in storedprocedure
can any one help in this issue

ck9663

This is a little tricky since a VIEW and table-function can sometimes act as tables. Although function should have the parenthesis. There's also a table variable and temp tables.

Do it the old fashion way: Read the stored proc.

Good luck

-- CK

how to get the list of tables used in a storedprocedure

re: how to get the list of tables used in a storedprocedure

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about