Re: How to duplicate a table complete with indexes? #

2002-02-12 Thread Rafal Jank
> > Quite often I'd like to duplicate an existing table using SQL. Normally I'd > do a > > create table NewTable select * from OldTable; > > and if I don't want any data transferred I'll slap on a Limit 0 on the end > of the statement. > > This works fine except it doesn't create any indexes

Re: Re: How to duplicate a table complete with indexes? #

2002-02-12 Thread Brian Reichert
On Fri, Feb 08, 2002 at 09:09:39PM +0100, [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query This 'anti-spam' measure,

Re: How to duplicate a table complete with indexes? #

2002-02-12 Thread Paul DuBois
At 13:22 -0600 2/8/02, BD wrote: >At 10:34 AM 2/8/2002 , you wrote: > >Quite often I'd like to duplicate an existing table using SQL. >Normally I'd do a > >create table NewTable select * from OldTable; > >and if I don't want any data transferred I'll slap on a Limit 0 on the end >of the statement

Re: Re: How to duplicate a table complete with indexes? #

2002-02-08 Thread Brian Reichert
On Fri, Feb 08, 2002 at 09:09:39PM +0100, [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query This 'anti-spam' measure,

Re: How to duplicate a table complete with indexes? #

2002-02-08 Thread Paul DuBois
At 13:22 -0600 2/8/02, BD wrote: >At 10:34 AM 2/8/2002 , you wrote: > >Quite often I'd like to duplicate an existing table using SQL. >Normally I'd do a > >create table NewTable select * from OldTable; > >and if I don't want any data transferred I'll slap on a Limit 0 on the end >of the statement