I have joined a new team which is working on big Project for which several tables has been created and based on that several views and stored procedure has been created.
Real problem am facing is while creating dashboard. I need to select few fields which are available in several tables. I can figure out most of the fields in 1or 2 (view and stored procedure)
My doubt is:
1) Is there any way we can figure out which all tables were used to create those view and stored procedure.
Note: Please explain with suitable example or provide any reference link
Discussion posts and replies are publicly visible
Hi ,
You can check the view definition in the database.That script will include the required tables involved.
Thanks