Home » RDBMS Server » Server Administration » GETTING DESCRIPTION OF ALL VIEWS
GETTING DESCRIPTION OF ALL VIEWS [message #375035] Fri, 20 July 2001 04:19 Go to next message
David
Messages: 110
Registered: November 1998
Senior Member
Hi :-)
Anybody know how to get all information about view.
I export all sources and all table information with constraints and indexes. It's easy and I'v done it. But I don't know how to get the column description, type (for example 'with read only'), etc. for views.
System view 'all_views' isnt the right way for getting these information.

Thanks U so much for your advice :-)

David

Report message to a moderator

Re: GETTING DESCRIPTION OF ALL VIEWS [message #375048 is a reply to message #375035] Fri, 20 July 2001 08:00 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
in SQL*Plus
DESCR View_Name

Report message to a moderator

Previous Topic: Urgent -Order by
Next Topic: passing values and triggering an exe
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 20:59:23 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.