dbschema - without indexes

Posted in 2000

vtnguyen — Wed, 19 Apr 2000 03:04:47 GMT — source: Informix-list mailing list archive (1991-1998)

Hi there, Is there a way to use dbschema to get just the table definitions with out the indexes? The reason is because I am using PowerDesigner DataArchitect to reverse engineer the schema. Most of the tables don't have primary keys but have unique indexes and PowerDesigner automatically create primary keys base on the unique index. I don't want this to happen. It is even better if you know how to turn off/disable this option in PowerDesigner. Thanks in advace for your help. Cheers Tung

↪ replying to vtnguyen

QueriX 4GL / Mehdi — Thu, 20 Apr 2000 13:17:57 +0100 — source: Informix-list mailing list archive (1991-1998)

vtnguyen wrote: > Hi there, > > Is there a way to use dbschema to get just the table definitions with > out the indexes? > > The reason is because I am using PowerDesigner DataArchitect to reverse > engineer the schema. Most of the tables don't have primary keys but have > unique indexes and PowerDesigner automatically create primary keys base > on the unique index. I don't want this to happen. It is even better if > you know how to turn off/disable this option in PowerDesigner. > > Thanks in advace for your help. > > Cheers > Tung You can write a small program which would create a schema file for you, using your filters to do what you want. I know Art has contributed a program called myschema, I do not know how versatile it is. -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere Phoenix Windows GUI. (Front End to 4GL) Chimera Java GUI The only GUI you will ever need... (Front End to 4GL) Arachne Web Technology (Front End to 4GL on the Web & HTML Report Generator) ESQL/C Compiler For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------

↪ replying to vtnguyen

Watawinona — 20 Apr 2000 19:47:58 GMT — source: Informix-list mailing list archive (1991-1998)

>Subject: dbschema - without indexes >From: vtnguyen vtnguyen@home.com >Date: 19.04.00 05:04 W. Europe Daylight Time >Message-id: <38FD242F.64BA9327@home.com> > >Hi there, > >Is there a way to use dbschema to get just the table definitions with >out the indexes? > >The reason is because I am using PowerDesigner DataArchitect to reverse >engineer the schema. Most of the tables don't have primary keys but have >unique indexes and PowerDesigner automatically create primary keys base >on the unique index. I don't want this to happen. It is even better if >you know how to turn off/disable this option in PowerDesigner. > >Thanks in advace for your help. > >Cheers >Tung > > > > > > > > just read out the systables where tabid > 99. Nona