Sharing Inline Defaults

Adaptive Server 15.7 supports sharing inline defaults between different tables if the tables are in the same database.

Before creating a new inline default, Adaptive Server looks for an existing shareable inline default having the same value in the database belonging to the same user. If Adaptive Server finds an existing shareable default, it 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.

Adaptive Server cannot share inline defaults in tempdb.

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