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

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.

yakoob pasha16y

Also, DEFAULTS cannot be applied to TIMESTAMP column.

Sam Ponnaiah16y

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.

Sam Ponnaiah16y

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

3 Answers