How to Add a Default Value to a Column in MS-SQL

SQL Tutorial Home

In order to add a default value in MS-SQL Server, use alter table and add a default constraint as shown in the example:

alter table employee add constraint last_bonus_default 
                     default getdate() for last_bonus;

The default value will be added to all new records if no other value is specified.

IN THIS PAGE