Copying Table

I need to manipulate an existing Table. But before doing so I want to create
a back-up, TEMP table and copy the contents just to protect myself.
Is there an easy way to do this in SQL Server Enterprise Manager or do I
have to write SQL Queries in order to accomplish this?
I am from the DB2 world and I know in the DB2 world we would SHOW the table,
copy and paste the columns and their attributes and then paste them, rename
the table, and then accomplish the task.
I am somewhat new to the SQL Server world so can the experts out there tell
me the most efficient way to to this in the SQL Server world?
Thanks in advance!Right click on the table name then select export data. Follow the wizard to
create a DTS package.
--
Thomas
"wnfisba" wrote:

> I need to manipulate an existing Table. But before doing so I want to crea
te
> a back-up, TEMP table and copy the contents just to protect myself.
> Is there an easy way to do this in SQL Server Enterprise Manager or do I
> have to write SQL Queries in order to accomplish this?
> I am from the DB2 world and I know in the DB2 world we would SHOW the tabl
e,
> copy and paste the columns and their attributes and then paste them, renam
e
> the table, and then accomplish the task.
> I am somewhat new to the SQL Server world so can the experts out there tel
l
> me the most efficient way to to this in the SQL Server world?
> Thanks in advance!|||Couple of options:
1. DTS the data out of the table i.e., to a file
2. BCP (out) the data out of the table i.e., to a file
3. Create a copy of the table in the same or different database (i.e.,
SELECT... INTO)
HTH
Jerry
"wnfisba" <wnfisba@.discussions.microsoft.com> wrote in message
news:4B937AAC-FD59-4C86-847A-10FE52973ABA@.microsoft.com...
>I need to manipulate an existing Table. But before doing so I want to
>create
> a back-up, TEMP table and copy the contents just to protect myself.
> Is there an easy way to do this in SQL Server Enterprise Manager or do I
> have to write SQL Queries in order to accomplish this?
> I am from the DB2 world and I know in the DB2 world we would SHOW the
> table,
> copy and paste the columns and their attributes and then paste them,
> rename
> the table, and then accomplish the task.
> I am somewhat new to the SQL Server world so can the experts out there
> tell
> me the most efficient way to to this in the SQL Server world?
> Thanks in advance!sql