/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

5 votes376 views1 answer
Mysql count lines
SQL
8 votes349 views1 answer
My sql version
SQL
2 votes321 views2 answers
Mysql show table column comments sql
SQL
0 vote304 views1 answer
Mysql max number not returning correct value
SQL
0 vote327 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
25 votes356 views4 answers
Sqlserver add column
SQL
0 vote333 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote318 views2 answers
Insert into
SQL
3 votes324 views1 answer
Force using index oracle
SQL
3 votes346 views1 answer
Only join in sql
SQL