Post
Ask Question

Sapna Malik
What are defaults? Is there a column to which a default can't be bound?
By Sapna Malik in SQL Server on Sep 20 2009
  • yakoob pasha
    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
  • Sam Ponnaiah
    Jan, 2010 24

    Also, DEFAULTS cannot be applied to TIMESTAMP column.

     

    • 0
  • Sam Ponnaiah
    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

View All

MOST LIKED QUESTIONS