Hi
I'm trying to Create a new Table from existing table in Q/Analyzer. I figured it would be something like this:
CREATE TABLE newTable AS
(SELECT * FROM OldTable);
but i keep getting
Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'AS'.
also.. is there another method of doing this, something like
INSERT INTO newTable
(SELECT * FROM OldTable);
and it creates the table ( newTable ) for u if it doenst already exist??
Cheers!!!
im using sql2000
You can try this one:
SELECT
* INTO newTableFROM OldTable|||The easiest method to copy a table with data is :
SELECT * INTO MyNewTable FROM MyTable
Note: this method does not copy constraints and indexes.
|||SELECT * INTO will create the table and also transfer the data. If you just want the table structure you can do
SELECT * INTO newTable FROM OldTable WHERE 1=0
You would need to add any constraints/indexes manually.
|||Thanks for ya help fellas
all helpfull answers
Cheers!!!
