Re: Is there an sql command that I could run on a users schema to generate the sql code for the creation of those objects?

Scott Kerr wrote:

> Hi,
> Is there an sql command that I could run on a users schema to
> generate the sql code for the creation of those objects? I
> have the DESC command, but
> that only lists fields and properties. The TEXT from
> USER_OBJECTS dose not include TABLES. Is there a way to
> generate the whole thing? I need to send the create script for
> a development database to a QA database. I could exp the
> database, and they could reinstall it, but I would like to see
> the SQL create code as well. Thanks,
> Scott Kerr
>
>

No, but a CASE tool such as ERwin, Embarcadero's SQL Studio or Oracle Designer can be used to reverse engineer a user's schema.

-- 
Jerry Gitomer
Once I learned how to spell DBA, I became one