Copying entire table to a new table?

[Cineno]

I have two tables that are structured exactly the same. Is there an easy way to copy all of the data from one table into the second table?

I'm not sure if this an elementary thing to do, I'm new with SQL. So is there an easy SQL statement that will just make this second table identicle to the first table?

Thanks for any help!

 

[gmmastros]

[tt][blue]Insert Into EmptyTable Select * From ExistingTable[/blue][/tt]

Usually, you want to specify the fields, but if the table structures are identical (including the ordinal positions of the fields), then the above syntax should work.

If the table structures are different, or the ordinal positions are different, then the expanded format would be...

[tt][blue]
Insert Into EmptyTable(Field1, Field2, etc...)
Select Field1, Field2, etc...
From ExistingTable
[/blue][/tt]

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[AlexCuse]

something like this:

select [ID], [TEST]
into tblName1
 from tblName

HTH,

Alex

Professor: But what about your superintelligence?
Gunther: When I had that there was too much pressure to use it. All I want out of life is to be a monkey of moderate intelligence who wears a suit. That's why I've decided to transfer to Business School.
Professor: NOOOOOOOOOOOO.

 

[gmmastros]

Select into will create a table, whereas insert into will add data to an existing table.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Cineno]

It worked great, thanks for such quick help!

 

[DocuMan]

If you need to do this repeatedly, use

TRUNCATE TABLE target_table

before you run the query.