By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

how to get the list of tables used in a storedprocedure

P: 3
how to get the list of all tables and views used in storedprocedure
can any one help in this issue
Oct 29 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
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
Oct 29 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.