Msg 1754, Level 16, State 0, Line 1
Defaults cannot be created on columns with an IDENTITY attribute. Table ‘%.*ls’, column ‘%.*ls’.
This error message appears when you try to create a DEFAULT on a column with the IDENTITY property.
The T-SQL statement can be parsed, but causes the error at runtime.
Error of the Severity Level 16 are generated by the user and can be fixed by the SQL Server user. The statement cannot be executed this way. You cannot create a DEFAULT constraint for a column with the IDENTITY property.
All versions of SQL Server.
CREATE TABLE #t
i1 INT IDENTITY NOT NULL DEFAULT 0
IDENTITY values are automatically handled by SQL Server. The specification of a DEFAULT constraint for such a column in unnecessary and raises the error.