SQL SERVER: SQL Query To Find Table Dependencies04/08/2009
|We have very large database and today we want to search the tables which are used mostly.
Means tables which are used in Procedures, Constraints, Views, Triggers etc.
I know this is very strange requirement, but we need to do this.
So, I tried to make an query which will help me to find out the top most tables used in other objects as I mentioned
Let me share that sp with all of you:
SELECT TableName, COUNT(*)
So, I made my life easy, by using this. I can get the list if Tables which are used most.
Let me know if it helps you in any way.