Create table syntax

[DanAuber]

The following would work in Oracle (I think) - what would the syntax be in SQL Server SQL ??

Create table xxx as (select * from yyyy);

yyyy being an existing table with data in it

Thanks for any help





Dan Auber
DanAuber@aol.com

http://members.aol.com/_ht_a/danauber/myhomepage/

 

[foxbox]

create table xxx( <define your structure> )

insert xxx
SELECT * from yyy

? br
Gerard
(-:

Better a known bug then a new release.


| Do it!
|
V

 

[foxdev]

[tt]select *
into MyNewTable
from MyExistingTable [/tt]

This allows you to do it all in one step. You can add an optional WHERE clause if desired. The destination table must not exist. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org

 

[ScottAW]

One warning about using foxdev's &quot;select into&quot; idea. A select into statement will lock the table you are selecting from until the operation is complete, so I recommend doing that afterhours. If you can't wait, then create the table and just append into it, as suggested by foxbox.