enable inline default sharing

Summary information

Default value

0 (off)

Valid values

0 (off), 1(on)

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

Application Functionality

enable inline default sharing enables Adaptive Server to share inline defaults. That is, once this configuration is enabled, Adaptive Server looks for existing shareable inline defaults having the same value in the database belonging to the same user. If it finds an existing shareable default, Adaptive Server binds this object to the column instead of creating a new default. However, if Adaptive Server does not find an existing shareable inline default, it creates a new default

See “Defining Defaults and Rules for Data” in the Transact-SQL Users Guide.