Re: table creation scripts?

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.

[Quoted] 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 Apr 28 1998 - 00:00:00 CEST