Forum Discussion
AfrazKhan
Feb 08, 2019Copper Contributor
"Create Table as" clause issue
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
Sort By
- okkeshkundakciCopper Contributor
Hello,
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,
- yavuzfilizlibayCopper Contributor
AfrazKhan you can use SELECT INTO command