Share Inline Defaults

When you create a new inline default, SAP ASE looks for an existing shareable inline default that have the same value in the database belonging to the same user. If one exists, SAP ASE binds this object to the column instead of creating a new default.

However, if SAP ASE does not find an existing shareable inline default, it creates a new default.

SAP ASE shares inline defaults between tables only within the same database.

Enable shared inline defaults by setting enable functionality group to a value greater than 0. See, Setting Configuration Parameters, in the System Administration Guide, Volume 1.

• Create an Inline Shared Default
  SAP ASE automatically creates and uses sharable inline defaults when the default clause is used in create table or alter table commands.
• Unbind a Shared Inline Default
  You cannot explicitly unbind a sharable inline default from a column. SAP ASE automatically unbinds or drops it from the column during drop table or alter table commands.
• Limitations for Shared Inline Defaults
  Certain limitations apply to shared inline defaults.