August 5, 2004 at 6:36 pm
I am working on a SQL 2000 server where the base tables are defined in one data base and the views are defined in a second data base with the views pointing to the base tables in the first database.
The information schema views (VIEW_table_USAGE or VIEW_COLUMN_USAGE) do not return any data on the base tables.
I have performed some sysobject queries and can find no entries for the base tables and columns in the second database. That is logical.
My question is, where is the dependency information stored? I am trying to prepare some dictionary reports and I need this information.
TIA -- Ron
August 5, 2004 at 8:48 pm
I'm afraid the only place to get that information is from the views themselves. The sysdepends and the INFOMATION_SCHEMA views are limited to a single database's objects.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 6, 2004 at 8:24 am
Thanks. I was hoping that I had overlooked some magic door.
Ron
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply