SQL SERVER – Add Column With Default Column

SQL SERVER – Add Column With Default Column


ALTER TABLE TestTable
ADD NewCol VARCHAR(50)
CONSTRAINT DF_TestTable_NewCol DEFAULT '' NOT NULL



ALTER TABLE Engineers
ADD book bit default '0'


Finally, you may wish to add a default constraint to an existing table. This uses the ALTER TABLE statement. The statement syntax is similar to that for adding a column specification except that in this case you specify that you wish to add a default constraint. As no column is being added, the previous default constraint syntax must be modified slightly to specify the name of the column being modified. The complete syntax is therefore:



----------------------------------------

ALTER TABLE table-name
ADD CONSTRAINT constraint-name DEFAULT default-value FOR column-name