Create Defaults

Define a default using create default, then bind the default to the appropriate table column or user-defined datatype using sp_bindefault.

You can test the bound default by inserting data.

You can drop defaults using drop default and remove their association using sp_unbinddefault.

When you create and bind defaults: