Add Rows Without Values in All Columns

You can specify values for only some of the columns in a row. Certain rules will apply when adding rows without values for all columns.

Default Exists for Column or Datatype

Column Defined NOT NULL

Column Defined to Allow NULL

Column is IDENTITY


The default

The default

Next sequential value


Error message


Next sequential value

Use sp_help to display a report on a specified table or default, or on any other object listed in the system table sysobjects. To see the definition of a default, use sp_helptext.

Related concepts
Defining Defaults and Rules for Data