"Create Table as" clause issue

Occasional Visitor

Hey all there, I am trying to create a new table in MSSQL Server 2017 from two other existing tables. 

Currently, i am using "Create table as" clause but unfortunately it brings syntax error as in below screenshot attached.

But, interestingly, same task is accomplished by using "Select INTO" clause.So my question is that

"Create Table AS" is valid in MSSQL Server or not ? 

2 Replies

@AfrazKhan you can use SELECT INTO command




   I think, "Create table as" clause is not supported by SQL Server but Azure SQL Data Warehouse is supporting this clause.


you should see the link as follows



Good days,