Posted by Flemming on 11/24/07 09:21

>>Is there a smarter way?
>>
>>Flemming
>>
>
>
> I'd run a separate command to create your new table, then use
>
> SELECT * INTO NewTable FROM OldTable;
>
> Of course I'd do a regular backup of your entire database first, just for
> precautionary measures.
>
Thank you your reply.

Is there a way to create (an empty) NewTable in SQL with indexes and all
from OldTable?

Flemming

• Next in forum: MI5 Persecution: .net Magazine Applauds my Website (12355)
• Prev in forum: Re: How do I copy a table for backup and restore purposes
• Thread view: Re: How do I copy a table for backup and restore purposes

[Reply to this message]