Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Generating CREATE TABLE statements

Re: Generating CREATE TABLE statements

From: Arto Viitanen <arto.viitanen_at_csc.fi>
Date: Tue, 31 Jan 2006 10:24:41 +0200
Message-ID: <43df1ec9$0$10072$ba624cd0@newsread.funet.fi>


Jack Miller wrote:
> 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

Oracle's Raptor has a tab (subwindow) called "SQL" for table. It shows the create table (tablespace etc. included), grants, indexes, primary and foreign keys.

--
Arto Viitanen, CSC Ltd
Espoo, Finland
Received on Tue Jan 31 2006 - 02:24:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US