Re: Schema Description

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: Mon, 09 Nov 1998 14:24:20 +0100
Message-ID: <3646ED04.37CCA3C3@psi.de>

The tool Hora 3 has the menu item "tools|Reverse Database Engineer ...". You can choose to generate the complete DDL of the selected schema or only parts of it. See ftp:\\www.keeptool.com for a 30 days free trial version of Hora 3.

regards Jan.Dieckmann

Igor wrote:

> Hi all,
>
> I need a SQL script that provides me with the
> description of a particular schema or instance
> so I can run it elsewhere and find out their differences.
>
> This must be quite exact. I need to spot any change on field,
> trigger or index object. I bet I need to query user_objects
> but an experienced advice would be much appreciated.
>
> Thanks in advance
>
> Igor
Received on Mon Nov 09 1998 - 07:24:20 CST