/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

2 votes292 views1 answer
Oracle drop table free up space
SQL
0 vote289 views2 answers
How to update the multiple rows in sql
SQL
0 vote314 views1 answer
Oracle locked objects
SQL
1 vote297 views2 answers
Drop function in sql
SQL
0 vote285 views1 answer
Oracle synonym procedure dblink
SQL
0 vote331 views1 answer
Oracle show grants on table
SQL
0 vote277 views1 answer
Oracle right characters
SQL
3 votes366 views1 answer
Oracle list invalid password logon denied
SQL
0 vote338 views1 answer
How to locate pg_hba.conf file
SQL
1 vote296 views4 answers
Mysqldump 1 table only
SQL