Re: table creation scripts?

You can do an export of the table w/o the data and that should also work.

-- 
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com

sokol_at_opsb.ru wrote in article <6i8p3j$4fs$1_at_nnrp1.dejanews.com>...
[snip]


> In article <354633C2.1DE4_at_nortel.ca>,

>   Peter Chan <chanp_at_nortel.ca> wrote:

> >

> > I was wondering if there is a tool out there that could help recreate

> > table creation scripts.

> >

> > That is, let's say I wrote a creation script to create a table, then

> > after running the script to create the table, I accidently lost the

> > script and I would like to be able to look back at the creation scripts

> > to see what type of parameters I have set for the table,

> >

> > ie. constraints, which tablespace table was created on, extent sizes,
[Quoted] 
> >     etc...

> >

> > Thanks a bunch!