Copy Table

I have a DB which will have many tables that are the same only named
differently. Instead of recreating each one is there a way to "Copy Table" ?
Thanks in advanceIt is possible to "copy" a table via a SELECT statement
Lets say you have a table called foo and you want to copy it to a table =named bar.
This will copy the structure and data:
SELECT * INTO bar FROM foo
This will copy the structure:
SELECT * INTO bar FROM foo WHERE 0=3D1
Note: you have to have the select into/bulkcopy dboption set to 'on' for =this method to work.
-- Keith
"Jim Campau" <Jim_Campau@.bausch.com> wrote in message =news:uA1kPus1DHA.1760@.TK2MSFTNGP10.phx.gbl...
> I have a DB which will have many tables that are the same only named
> differently. Instead of recreating each one is there a way to "Copy =Table" ?
> > Thanks in advance
> >|||Hi,
Use the command
select * into newtablename from tablename
The above command copy the table along with data
select * into newtablename from tablename where 1=2
The above command copy the table structure only.
Thanks
Hari
MCDBA
"Jim Campau" <Jim_Campau@.bausch.com> wrote in message
news:uA1kPus1DHA.1760@.TK2MSFTNGP10.phx.gbl...
> I have a DB which will have many tables that are the same only named
> differently. Instead of recreating each one is there a way to "Copy Table"
?
> Thanks in advance
>