Add a column with a default value to an existing table in SQL Server

DEFAULT fills the column in existing rows with the default value

Example:



Alter table with Default Value..

Example:

ALTER table seasonhead ADD TESTID int NOT NULL DEFAULT 5