ADSM-L

Re: SQL table layout

1998-02-25 11:25:49
Subject: Re: SQL table layout
From: Matthew Warren <mwarren AT OSMF.BT.CO DOT UK>
Date: Wed, 25 Feb 1998 16:25:49 -0000
Hello,

        You can get a summary of the tables / columns etc by doing a

select * from syscat.columns    for column info
select * from syscat.tables     for table info
select * from syscat.enumtypes  for details on the enumerated data types

        It doesnt come out in a nice format though, but it can be laid out 
easily if redirected to a file.

Matthew Warren

<Prev in Thread] Current Thread [Next in Thread>