SA0156 : Statements CREATE/DROP DEFAULT are deprecated. Use DEFAULT keyword in CREATE/ALTER TABLE
The topic describes the SA0156 analysis rule.
Statements CREATE/DROP DEFAULT are deprecated. Use DEFAULT keyword in CREATE/ALTER TABLE
The rule checks for usage of the deprecated CREATE/DROP DEFAULT statements.
This feature will be removed in a future version of Microsoft SQL Server.
Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Instead, use default definitions created using the DEFAULT keyword of ALTER TABLE or CREATE TABLE.
The rule has a Batch scope and is applied only on the SQL script.
Rule has no parameters.
The rule does not need Analysis Context or SQL Connection.
Design Rules, Deprecated Features, Code Smells
1--DROP DEFAULT phonedflt; 2CREATE DEFAULT phonedflt AS 'unknown';
|1||SA0156 : Deprecated CREATE/DROP DEFAULT statement. Use DEFAULT keyword in CREATE/ALTER TABLE.||2||1|