I want the get all the views along with its base tables/ objects which are missing their references as they got deleted while some operations. So, can anyone help me?
Asked
Active
Viewed 281 times
1
-
This may have what you need: http://stackoverflow.com/questions/6616245/how-do-i-identify-views-with-broken-dependencies-in-sql-server – yelxe Jun 28 '16 at 00:11
-
Thanks for your help. Actually, I just want to find out tables/ view in all the procedures in particular database separating its object type as table/view – Ash Atre Jun 28 '16 at 23:03