Admin Tools Forum

Re: show view

Posted By: Art Kagel
Date: Friday, 25 July 2008, at 10:25 a.m.

In Response To: show view (MARK DURSHIMER)

Run:

dbschema -d <databasename> -t <table, view, or synonym name> -ss

That will print out the SQL DDL definition of any table-like object that's
not a system catalog or pseudo table (to see the DDL for those you'll have
to download and compile my dbschema replacement utility, myschema, which is
contained in the package utils2_ak in the IIUG Software Repository or from
the Oninit website at: www.oninit.com/utils - select myschema the press the
VIEW button at the bottom of the README output). Myschema will display DDL
for system catalog and pseudo tables.

Art

On Fri, Jul 25, 2008 at 10:16 AM, MARK DURSHIMER <fabasard@bikerider.com>
wrote:

> Hi, I would like ot know if there is a way to display the SQL source of a
> view
> once the view has been created. We are running two informix servers with
> WINSQL Lite and I have a view on one of the servers (I did not create the
> view) and would like to replicate a similar view on the other server, but
> need
> to know the syntax of how the view was created. Any help would be greatly
> appreciated. I had hoped that there might be a SHOW VIEW <view name>, or
> something to that effect.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>

--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.

Messages In This Thread

• show view
  MARK DURSHIMER -- Friday, 25 July 2008, at 10:16 a.m.
  • RE: show view
    Lapeire, Jacques -- Friday, 25 July 2008, at 10:25 a.m.
  • Re: show view
    Art Kagel -- Friday, 25 July 2008, at 10:25 a.m.
    • Re: show view
      MARK DURSHIMER -- Friday, 25 July 2008, at 10:55 a.m.
      • Re: show view
        Art Kagel -- Friday, 25 July 2008, at 11:11 a.m.
      • Re: show view
        ptang83@yahoo.com -- Friday, 25 July 2008, at 11:29 a.m.
      • Re: show view
        ptang83@yahoo.com -- Friday, 25 July 2008, at 11:45 a.m.
        • Re: show view
          MARK DURSHIMER -- Friday, 25 July 2008, at 12:12 p.m.
  • Re: show view
    June Nebab -- Friday, 25 July 2008, at 10:51 a.m.

Admin Tools Forum is maintained by Administrator with WebBBS 5.12.