dbschema - without indexes
vtnguyen wanted dbschema output without indexes so PowerDesigner would not create primary keys from unique indexes, or a way to disable that in PowerDesigner. Mehdi (QueriX 4GL) suggested writing a small custom schema program and mentioned Art's myschema utility. Watawinona suggested reading systables where tabid > 99. No confirmed dbschema option was given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
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/
---------------------------------------------------------------------------------------------------
>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