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

Yes

The default

The default

Next sequential value

No

Error message

NULL

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