Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Art S. Kagel — — source: Usenet: comp.databases.informix
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.