Mark Forums Read

Copy a table in SQL Server 2005

Go Back

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

Reply

Page 1 of 10

1

#1

Old

David

Posts: n/a

Copy a table in SQL Server 2005 - 01-15-2008 , 08:12 AM

Hello all

I want to make a copy of a table in SQL Server 2005, a back-up of my table
if you will. I don't see any way of doing this, I am I right in assuming
that one can't copy a table in an SQL Sever 2005 database?

ie: MyTable -> MyTableCOPY = 2 Tables in the same database

Thank you for your time.

Regards

David

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Reply With Quote

#2

Old

Leon Mayne

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:22 AM

"David" <someone (AT) someisp (DOT) com> wrote

Quote:

I want to make a copy of a table in SQL Server 2005, a back-up of my table
if you will. I don't see any way of doing this, I am I right in assuming
that one can't copy a table in an SQL Sever 2005 database?

Just use
select * into newtable from oldtable

Reply With Quote

#3

Old

Leon Mayne

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:22 AM

"David" <someone (AT) someisp (DOT) com> wrote

Quote:

I want to make a copy of a table in SQL Server 2005, a back-up of my table
if you will. I don't see any way of doing this, I am I right in assuming
that one can't copy a table in an SQL Sever 2005 database?

Just use
select * into newtable from oldtable

Reply With Quote

#4

Old

Leon Mayne

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:22 AM

"David" <someone (AT) someisp (DOT) com> wrote

Quote:

I want to make a copy of a table in SQL Server 2005, a back-up of my table
if you will. I don't see any way of doing this, I am I right in assuming
that one can't copy a table in an SQL Sever 2005 database?

Just use
select * into newtable from oldtable

Reply With Quote

#5

Old

Leon Mayne

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:22 AM

"David" <someone (AT) someisp (DOT) com> wrote

Quote:

I want to make a copy of a table in SQL Server 2005, a back-up of my table
if you will. I don't see any way of doing this, I am I right in assuming
that one can't copy a table in an SQL Sever 2005 database?

Just use
select * into newtable from oldtable

Reply With Quote

#6

Old

Leon Mayne

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:22 AM

"David" <someone (AT) someisp (DOT) com> wrote

Quote:

I want to make a copy of a table in SQL Server 2005, a back-up of my table
if you will. I don't see any way of doing this, I am I right in assuming
that one can't copy a table in an SQL Sever 2005 database?

Just use
select * into newtable from oldtable

Reply With Quote

#7

Old

Leon Mayne

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:22 AM

"David" <someone (AT) someisp (DOT) com> wrote

Quote:

I want to make a copy of a table in SQL Server 2005, a back-up of my table
if you will. I don't see any way of doing this, I am I right in assuming
that one can't copy a table in an SQL Sever 2005 database?

Just use
select * into newtable from oldtable

Reply With Quote

#8

Old

Uri Dimant

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:25 AM

David
You can script out (with the data) the table and save it on the disk.

"David" <someone (AT) someisp (DOT) com> wrote

Hello all

I want to make a copy of a table in SQL Server 2005, a back-up of my table
if you will. I don't see any way of doing this, I am I right in assuming
that one can't copy a table in an SQL Sever 2005 database?

ie: MyTable -> MyTableCOPY = 2 Tables in the same database

Thank you for your time.

Regards

David

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Reply With Quote

#9

Old

Uri Dimant

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:25 AM

David
You can script out (with the data) the table and save it on the disk.

"David" <someone (AT) someisp (DOT) com> wrote

Hello all

I want to make a copy of a table in SQL Server 2005, a back-up of my table
if you will. I don't see any way of doing this, I am I right in assuming
that one can't copy a table in an SQL Sever 2005 database?

ie: MyTable -> MyTableCOPY = 2 Tables in the same database

Thank you for your time.

Regards

David

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Reply With Quote

#10

Old

Uri Dimant

Posts: n/a

Re: Copy a table in SQL Server 2005 - 01-15-2008 , 08:25 AM

David
You can script out (with the data) the table and save it on the disk.

"David" <someone (AT) someisp (DOT) com> wrote

Hello all

I want to make a copy of a table in SQL Server 2005, a back-up of my table
if you will. I don't see any way of doing this, I am I right in assuming
that one can't copy a table in an SQL Sever 2005 database?

ie: MyTable -> MyTableCOPY = 2 Tables in the same database

Thank you for your time.

Regards

David

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Reply With Quote

Reply

Page 1 of 10

1

« Previous Thread | Next Thread »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.