DDL : Binding Rules to Colunms

Default values for colunms can be specified at the time a table is created, or
afterwards via the modify command.

/* Employee will have a default salary of 10000, and a hire date of today */

create table employee (
emp_id integer not null,
salary money default 0,
hire_dt datetime default getdate()
)
go


/* alter the table, so salary starts at 49000 */

ALTER TABLE employee REPLACE salary DEFAULT 49000
go


/* create a new default; bind the column to your custom default */

create default def_highsal as 55000
go
sp_bindefault def_highsal,'employee.salary'
go

-- creating your own custom defaults has a significant advantage:
-- you can actually choose the name of the default.