CREATE TABLE AS

[atiqraza]

Any Reason why the Query

"CREATE TABLE AS" is not working in sql server 2005. I am trying to create a table from the result return of a query.
I am using the simple format
CREATE TABLE TABLE_NAME AS select * from table1

it keeps giving me this error

Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'as'.

 

[gmmastros]

The correct syntax would be...

select * Into Table_Name from table1

-George

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

 

[atiqraza]

Hey George,

Thnx for the reply but i am not using a table i am using a querry's return to create the new table, for some reason this syntax does not support it...OR does it ?

 

[gmmastros]

Do you want to create a View?

CREATE [!]VIEW[/!] TABLE_NAME AS select * from table1




-George

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