/SQL/Alter column to not null with default value sql server

Alter column to not null with default value sql server

ALTER TABLE SomeTable
        ADD SomeCol Bit NULL --Or NOT NULL.
 CONSTRAINT D_SomeTable_SomeCol --When Omitted a Default-Constraint Name is autogenerated.
    DEFAULT (0)--Optional Default-Constraint.
WITH VALUES --Add if Column is Nullable and you want the Default Value for Existing Records.

Source: stackoverflow.com

Similar codes

0 vote145 views1 answer
Mysql record group by created date count
SQL
16 votes145 views1 answer
Sqlserver add column to table
SQL
0 vote167 views1 answer
Get create sql of hibernqte entity
SQL
0 vote131 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote180 views1 answer
ALV GRID events
SQL
0 vote149 views1 answer
Null column as zero in mysql
SQL
2 votes155 views1 answer
How to get weekday from old date in sql
SQL
1 vote140 views2 answers
How to check username in mysql command line
SQL
2 votes163 views1 answer
Oracle apex who is connected
SQL
0 vote145 views1 answer
How to get inserted id in sql server
SQL