What are defaults? Is there a column to which a default can't be bound?

Post

By Sapna Malik in SQL Server on Sep 20 2009

Jul, 2010 29
hi,
Defaults are the user defined constraints. Their role is to insert a default value to a column if that column contains only 'null' value at the time of insertion.
Defaults cannot be defined for primary key column, unique key column, identity columns.
Thank you.
- 0
Jan, 2010 24
Also, DEFAULTS cannot be applied to TIMESTAMP column.
- 0
Jan, 2010 24
The DEFAULT constraint is used to insert a default value into a column, when no value is specified in the INSERT statement. DEFAULTS are created using CREATE TABLE or ALTER TABLE statements. The DEFAULT can't be bound to an IDENTITY column.
- 0

Most Popular Job Functions