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