Error on simple create table statement

Question

SQL Server 2016. Why is this simple Create Table statement invalid? Seems like it should be straight forward.

IntelliSense says

If this is a required parameter, which one do I choose and why?

Answer 1

There is no CREATE TABLE AS(subquery) in SQL Server 2016 syntax. Instead, use SELECT INTO to create a new empty table based on the result set schema:

SELECT *

INTO dbo.djmdev03

FROM dbo.datetable

WHERE 1 = 2;