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

SELECT * INTO NewTable FROM OldTable

--
Andrew J. Kelly SQL MVP

"Omar Abid" <omar.abid2006 (AT) gmail (DOT) com> wrote

Quote:

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

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

Duplicate table

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

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

Re: Duplicate table - 06-11-2007 , 02:46 PM