Oracle Database discussion - Generating CREATE TABLE statements

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Generating CREATE TABLE statements

Jack Miller

2006-01-30, 11:23 am

Hi,

Is there any SQL command in Oracle that returns a "CREATE TABLE"
statement in Oracle. For example in MySQL there is a command called

"SHOW CREATE TABLE <tableName>"

This command can be sent from any client and it returns the script for
the table.

Thanks

Jim Kennedy

2006-01-30, 8:23 pm

"Jack Miller" <jm@asdfaf.com> wrote in message
news:swrDf.2327$0J3.1435@trndny08...
> Hi,
>
> Is there any SQL command in Oracle that returns a "CREATE TABLE"
> statement in Oracle. For example in MySQL there is a command called
>
> "SHOW CREATE TABLE <tableName>"
>
> This command can be sent from any client and it returns the script for
> the table.
>
> Thanks
look at the docs under pl/sql packages dbms_metadata.
Jim

Sponsored Links