Re: Finding the definition of a view

Daniel Lieuwen <lieuwen> wrote:

>Assuming one has DBA priveleges, how does one find the definition of a
>view? No one remembers the exact definition off hand, and we need it back.
 

>Also, where can one find a complete list of system table (e.g. TABS, COLS)?
>Since they don't show up in TABS itself and I can't find even TABS and COLS
>in the indexes of any of the stack of about 10 books that came with the
>distribution, I'm out of ideas as to where to look.
 

>Thanks.
 

>Daniel

Select Text from All_Views where View_name='...' and owner='...';

ALL_TABLES/ALL_TAB_COLUMNS contain all the table definitions. Refer Server Admin doc for more info.

sm Received on Mon Jan 29 1996 - 00:00:00 CET