Hi Experts, I put myself about 2 or max 3 /10 and manage my work by getting tables i need to do analysis. However, the problem I have needs some smart help.
I have SSMS with views existing already.
Environment: SQL Server Management Studio - SQL
I have about 100 views, each view has many From -- tables and refers to another view and this goes on, I need help
Please can you help me with how should I approach these issues, is there a script that evaluates these relationships to other views? I need this as developers get the requirements.
My outputs needed: View Dependencies, Tables it refers to the base table etc.
Please advise and thank you.