Re: table creation scripts?

The one real weakness in SQLNavigator, which happens to pertain to this thread, is that it does not correctly reverse-engineer (RE) primary keys that are defined with the USING INDEX clause. In the Pro version it REs the index as a unique index, which gives you the storage information, and it REs the primary key constraint separately. When you run the script the primary key constraint will create an error, because the primary key columns duplicate the unique index columns.

Having said all that, I cannot live without it. It's a great tool.

Respectfully,

Clete Rodriguez
Western Asset

Michael Krolewski wrote:

> There are several/many out there. Oracle has them (Designer 2000).
>
> SQLNavigator (made by whom??) is quite excellent. It uses the information
> in Oracle. It can extract scripts for creating tables and other thing. And
> it has a good environment for debugging the PL/SQL.
>
> I recently came across a freeware (?) version written in OCI, Oracles low
> level C support. If you contact me I will forward the name/source. Not
> quite as good as SQL Navigator but really great for near free.
>
> Mike Krolewski
>
> Peter Chan wrote:
>
> > I was wondering if there is a tool out there that could help recreate
> > table creation scripts.
> >
> > That is, let's say I wrote a creation script to create a table, then
> > after running the script to create the table, I accidently lost the
> > script and I would like to be able to look back at the creation scripts
> > to see what type of parameters I have set for the table,
> >
> > ie. constraints, which tablespace table was created on, extent sizes,
> > etc...
> >
> > Thanks a bunch!
> >
> > --
> > ====================================================================
> > PETER CHAN, Northern Telecom
> > PHONE: (613) 763-9096 FAX: (613) 763-4408 EMAIL: chanp_at_nortel.ca
> > ====================================================================
Received on Tue May 05 1998 - 00:00:00 CEST