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