If you want to copy or backup your table in the database, use the following SQL command.
select * into newtable
The new table is created on the fly. You do not need to create it. A more descriptive example is below. Not that # means temporary table.
create table #table1(
id int not null primary key identity,
insert into #table1 values('john','hockey')
insert into #table1 values('Kim','footbal')
insert into #table1 values('Joe','soccer')
select * from #table1
— at this point only #table1 exists
— lets say want to want to backup table1, we will use
select * into #table2
At this point we will have #table2, which will be exactly same as table#. We can create a select query against #table2.