The system procedure sp_bindefault is used to bind the defined default value to specific columns. : sp_bindefault « System Functions « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Functions
3. sp_bindefault

3>
4> CREATE DEFAULT zip_default AS 94710
5> GO

1>
2> CREATE TYPE zip
3>   FROM CHAR(5) NOT NULL
4> GO

1>
2>
3> sp_bindefault 'zip_default', 'zip'
4>
5> --sp_unbindefault removes the connection between the default and the data type of the corresponding column.
6>
7> sp_unbindefault 'zip_default', 'zip'
8>
9> drop DEFAULT zip_default;
10>
11> drop type zip;
12> GO