Re: Generalized query to determine the table a query or a view's columns come from?

From: David Cressey <dcressey_at_verizon.net>
Date: Sat, 04 Mar 2006 13:25:32 GMT
Message-ID: <gzgOf.443$6h1.25_at_trndny09>


"professor chen" <mydejamail_at_yahoo.co.uk> wrote in message news:1141428741.365079.290190_at_t39g2000cwt.googlegroups.com...
> Is there way to determine the table a query or a view's columns come
> from?

I can only answer this question for DEC Rdb/VMS, which is not widely known. The answer is yes, at last for a view. The system tables keep track of the relationship between result columns and source columns for the contents of a view.

I would expect the same to be true for Oracle's data dictionary, and for the standard metadata now defined for SQL. But I haven't checked it out. Received on Sat Mar 04 2006 - 14:25:32 CET

Original text of this message