Re: DESCRIBE statement
On Tue, 27 Jan 2004 05:24:44 -0500, Xavier Autret wrote:
> Hello,
>
> In many DMBS we ve got the DESCRIBE statement.
>
> I've got an informix view and I want to see the code that define my view. I
> tried DESCRIBE <table> in dbaccess but an error occured.
>
> I don't want to see the columns but the code stored in the view.
Use the dbschema commandline utility:
dbschema -d <database> [-t <table/view>] [schemafile]
> Perhaps it is stored in a systeme table?
Yes. Look in sysviews joined to systables:
select viewtext
from systables st, sysviews sv
where st.tabid = sv.tabid
and st.tabname = "myviewname"
order by seqno;
Art S. Kagel
> Xavier