Hi, Mike. Try. select tabname, colname from columns

> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Anderson, Michael - HMIS
> Sent: Wednesday, August 22, 2001 3:10 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Select Question
>
>
>         Is there somewhere that I can find the sql names of the
> fields that
> are available in the different tables. For example I am trying
>      to query the event table for the start time, completed time, and the
> status  for specific nodes. I figured out the start time and status
>      but I am having trouble with the completed time. I guess what I am
> trying to say is, how can I see what info is in the table available
>      to me.  Also is there a way to get rid of the date from the
> start time.
>
>
>     Thanks
>     Mike Anderson
>     Michael_Anderson AT hmis DOT org
>
>
> CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
> is for the sole use of the intended recipient(s) and may contain
> confidential
> and privileged information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> contact the sender by reply e-mail and destroy all copies of the original
> message.
>