Msg 173, Level 15, State 1, Line 3
The definition for column ‘%1!’ must include a data type.
This error message appears when you try to create a column in a CREATE TABLE statement without specifying a datatype for that column.
The SQL statement cannot be parsed and further execution is stopped.
Error of the Severity level 15 are generated by the user and can be fixed by the SQL Server user. For each column in a CREATE TABLE there mandatorily has to be an explicit specification of the datatype for that column.
All versions of SQL Server.
CREATE TABLE t
DROP TABLE t
It is not allowed to create a table with column(s) for which the user has not specified a datatype. There is no standard datatype that is applied in such cases.