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: Walt <walt_askier_at_SHOESyahoo.com>
Date: Tue, 31 Jan 2006 11:28:28 -0500
Message-ID: <MeMDf.35$Ww1.17@news.itd.umich.edu>


DA Morgan wrote:
> Jack Miller wrote:

>> 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 

> SELECT dbms_metadata.get_data('TABLE', '<you_table_name>')
> FROM dual;

ITYM dbms_metadata.get_ddl()

> Demos of the dbms_metadata package can be found in Morgan's Library at
> www.psoug.org.

The OP didn't include an Oracle version, so for those playing along at home the dbms_metadata package was new in Oracle 9i.

Also, TOAD and Raptor provide a point and click interface to generate create table scripts.

//Walt Received on Tue Jan 31 2006 - 10:28:28 CST

Original text of this message

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