468,316 Members | 2,143 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,316 developers. It's quick & easy.

how to get the list of tables used in a storedprocedure

how to get the list of all tables and views used in storedprocedure
can any one help in this issue
Oct 29 '08 #1
1 1427
ck9663
2,878 Expert 2GB
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.

Similar topics

reply views Thread by amber | last post: by
2 posts views Thread by martin | last post: by
reply views Thread by Sandy | last post: by
1 post views Thread by Brian Henry | last post: by
2 posts views Thread by Henrik | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.