Default Column Value

This article describes the column default values supported by MSSQL Server 2005.

Overview

Default
Syntax	DEFAULT constant-expression; CREATE DEFAULT [ schema_name . ] default_name AS constant-expression [ ; ]
Description	Specifies the value provided for the column when a value is not explicitly supplied during an insert. DEFAULT definitions can be applied to any columns except those defined as timestamp, or those with the IDENTITY property
Allows Expressions	Only a constant value, such as a character string; a scalar function, either a system, user-defined, or CLR function; NULL can be used as a default
Not Allowed Expressions	All, exclude allowed expressions