Add a column with a default value to an existing table in SQL Server
Syntax: Example: Notes: Optional Constraint Name:If you leave out CONSTRAINT D_SomeTable_SomeCol then SQL Server will autogenerate a Default-Contraint with a funny Name like: DF__SomeTa__SomeC__4FB7FEF6 Optional With-Values Statement:The WITH VALUES is only needed when your Column is Nullable and you want the Default Value used for Existing Records.If your Column is NOT NULL, then it will automatically use the Default … Read more