select * from syscat.columns
select * from syscat.tables
select * from syscat.enumtypes

older versions will only have syscat.columns & tables... don't remember at
what time enumtypes was added, prior to that you just had to look & guess
;-)

Dwight

> ----------
> From:         wawork Wash[SMTP:wawork AT HOTMAIL DOT COM]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         Friday, July 14, 2000 10:28 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Where do I find the data model for ADSM?
>
> Hello,
>   Our Unix admin folks run the ADSM at our site.  Unfortunately they
> refuse
> to learn SQL.  I need to query the ADSM database.  Therefore, I need a
> list
> or diagram of tables and their fields that make up the ADSM database.  Can
> someone point me in the direction of either on-line documentation or tell
> me
> which manual I need to request from our Unix administrator?
>
> Thanks,
>   Randy
>   wawork AT hotmail DOT com
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>