view query containing a specific table or synonym
Hi all,
I need to scan all the views in a database which are using a specific table or synonym in the query used to pull the data. certainly I cannot go to each view and check the script as it would it take more time. please suggest any solution here.
Thanks.