Dale Fye
asked on
is table used by an views
At some point, when I first started working with SQL Server, I got the idea that it might be beneficial to take several Access databases and migrate the data to SQL Server. I had a set of tables which were common to several Access applications, so I figured I would put them into their own SQL Server database, but after a while I realized that separating the data from the Access applications was more trouble than it was worth, so I copied all of those tables into one database.
So, before I delete that common tables database, I would like to know if there is an easy way to identify object relationships within SQL Server. Specifically, I need to know whether any of the tables in that database are being used in any of the views, stored procedures, or UDFs in either that database, or any of the other databases on that server.
So, before I delete that common tables database, I would like to know if there is an easy way to identify object relationships within SQL Server. Specifically, I need to know whether any of the tables in that database are being used in any of the views, stored procedures, or UDFs in either that database, or any of the other databases on that server.
Starting with SQL 2008, you can use this view:
sys.sql_expression_depende ncies
sys.sql_expression_depende
ASKER
Thanks, Jim. That seems to work within a given database, but not across databases on the same server.
Scott, can you provide an example of how to use that? I've tried a couple of things, but nothing seems to work.
Dale
Scott, can you provide an example of how to use that? I've tried a couple of things, but nothing seems to work.
Dale
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for that recommendation, JIm. I'm going to use one of the several 3rd party apps.
If you go with Pragmatic Works mention that I went bull riding at Cowboy Jack's in Minneapolis with Brian Knight and Graham Bless, and referred you to them. Guessing it won't get you anything other than a couple of good yuks, although it'll keep me on their good side.
Thanks for the grade. Good luck with your Easter Egg hunt. -Jim
Thanks for the grade. Good luck with your Easter Egg hunt. -Jim
Guessing there are a number of third-party tools, probably Redgate and Pragmatic Works DOCxPress, that have this automated in such a way that it'll generate for all objects.