Duplicate table

#1

Hi,
In my program i need to duplicate a table in a current data base.
I'm thinkin' of reading the data base columns and then rows and so i
create another table
Is there any other easy and fast method with SQL Server 2005, because
my idea is so slow
I'm using VB 2005 Express with SQL Server 2005 Express
Thanks

#2

On 11 juin, 18:54, "Chris.Cheney" <Chris.CheneyXXNOSPA... (AT) tesco (DOT) net>
wrote:

Quote:

Omar Abid <omar.abid2... (AT) gmail (DOT) com> wrote in news:1181578579.728121.204320
@g4g2000hsf.googlegroups.com:

Hi,
In my program i need to duplicate a table in a current data base.
I'm thinkin' of reading the data base columns and then rows and so i
create another table
Is there any other easy and fast method with SQL Server 2005, because
my idea is so slow
I'm using VB 2005 Express with SQL Server 2005 Express
Thanks

SELECT * INTO NewTable FROM OldTable

Hi
Thx for your reply I'll try your code and submit the result to you
Omar Abid

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Duplicate table

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Duplicate table - 06-11-2007 , 11:16 AM

Re: Duplicate table - 06-11-2007 , 03:09 PM