Re: dbschema output

In article <4tq5hq$2vr@cssun.mathcs.emory.edu> r.thomas@csl.gov.uk "Richard Thomas" writes: > Hi everyone! > > Apologies in advance if I'm being thick, but I've read the manual, > and it doesn't seem to help. (OK, I'm using OnLine 7.13 and we've > only got v6.00 manuals, but that's another story!). What I want > are the create table statements for all tables in a database, but > without the triggers, procedures, privileges etc. I know I can do > a full dbschema and then edit the file, but it's a bit lengthy!! > > Is there an easier way to do this? (I'm want to get a single file > that I can load into S-Designor to get a "pretty picture" of my > database structure - it's documentation time!!). > A script to do exactly what you require is at the following FTP site: ftp://iiug.org/pub/informix/pub/dbsh.Z This (Perl) script takes the dbschema output and generates a CREATE and a DROP script for each entity type (tables, indexes, etc.). Hope this is of use... Stuart Knight stuart#century.demon.co.uk