On Fri, 2 Jan 2004, Roger Baklund wrote:
> * Gohaku
> > I was just curious if there's a shorthand way of replicating a Table
> > Schema.
> > I use the following to create a new Table with the same schema.
> > >create table new_table ( select * from table);
> > >delete from new_table;
>
> You can
* Gohaku
> I was just curious if there's a shorthand way of replicating a Table
> Schema.
> I use the following to create a new Table with the same schema.
> >create table new_table ( select * from table);
> >delete from new_table;
You can avoid the DELETE by specifying a non-true WHERE clause:
On Thu, Jan 01, 2004 at 05:42:59PM -0500, Gohaku wrote:
> Hi everyone,
> I was just curious if there's a shorthand way of replicating a Table
> Schema.
> I use the following to create a new Table with the same schema.
> >create table new_table ( select * from table);
> >delete from new_table;
CRE
