Re: table description
In article <318paj$2ks@dns1.NMSU.Edu> tbowman@nmsu.edu (Todd Bowman) writes:
>I am fairly new to Informix and have access only to the
>informix documents, no 3rd party tutorial books.
Welcome aboard. I liked it so much, I joined the company!
>My goal is, via an sql statemnt to grab a description of a
>particular table, including column names, type and size of
>data, indexes, not nulls, etc...
>
>Is there a system table that holds this info? If so can a user
>get at it?
Yes, and yes. Try "systables" and "syscolumns". I think it is
all in there. Null-ness or not-null-ness is coded a little
cryptically along with datatype. There is also "sysauth" or
something like that lists who has which permissions to which
tables.
You might start by saying:
select tabname
from systables
where tabname matches "sys*"
Very recursive, eh?
Paul