ADSM-L

Re: SQL Querries

1999-04-27 12:07:33
Subject: Re: SQL Querries
From: "Vraspir, Mary J." <MJVraspir AT WEST DOT COM>
Date: Tue, 27 Apr 1999 11:07:33 -0500
Danny,
You might try
Select distinct tabname from columns (tables works as well)
MV

        -----Original Message-----
        From:   Danny Miles [SMTP:Miles_Danny AT PROMINA DOT ORG]
        Sent:   Tuesday, April 27, 1999 9:23 AM
        To:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        Re: SQL Querries

        Hi Folks:

        This is from a newbie, so I'm not sure if this is what you want.
Try the following command from the Web GUI command line:

        show * from columns.

        Danny.

        >>> Richard Sims <rbs AT BU DOT EDU> 04/27 9:29 AM >>>
        >Does anybody have a list of all of the table and variable names?  I
would like
        >to put together some SQL querries but I can't find a list of tables
anywhere!!

        One reference, as previously mentioned on the List, is:
          http://www.uni-karlsruhe.de/~rz57/ADSM/3rd/handouts/raibeck.ps
<Prev in Thread] Current Thread [Next in Thread>