Re: How to view a view
Adrian Davis <adavis@lbdplc.demon.co.uk> wrote:
>I'm using SQL ver 4.1 on AIX.
>Having defined lots of views with fairly complex select statements, I
>can't see an easy way of displaying the view definitions. I can pull
>apart the sysviews table, but is there a simpler or more elegant
>solution?
Hallo Adrian,
use the INFORMIX Utility dbschema:
dbschema -d <database-name> -t <view-name>
This is not very nice but a little bit simpler.
Uwe
------------------------------------------------------------------
Uwe Droste Tel.: +49 421 / 537 02 30
Messerknecht Datensysteme GmbH Fax: +49 421 / 557 96 65
Georg-Wulf-Str. 18, 28199 Bremen E-Mail: ud@mds-hb.de
------------------------------------------------------------------