Default Category (DBMS)

The Default category is located in the Root > Script > Objects category, and can contain the following items that define how defaults are modeled for your DBMS.

Item

Description

[Common items]

The following common object items may be defined for defaults:

  • AfterCreate, AfterDrop, AfterModify

  • BeforeCreate, BeforeDrop, BeforeModify

  • Create, Drop

  • Enable, EnableOwner

  • Maxlen

  • ModifiableAttributes

  • ReversedQueries, ReversedStatements

  • SqlAttrQuery, SqlListQuery

For a description of each of these common items, see Common object items.

Bind

Specifies the command for binding a default object to a domain or a column.

When a domain or a column use a default object, a binddefault statement is generated after the domain or table creation statement. In the following example, column Address in table Customer uses default object CITYDFLT:

create table CUSTOMER (
  ADDRESS  char(10)  null
)
sp_bindefault CITYDFLT, 'CUSTOMER.ADDRESS'

If the domain or column use a default value directly typed in the Default list, then the default value is declared in the column creation line:

ADDRESS  char(10)  default 'StdAddr' null

PublicOwner

Enables PUBLIC to own public synonyms.

Unbind

Specifies the command for unbinding a default object from a domain or a column.

Example (ASE 15):

[%R%?[exec ]][execute ]sp_unbindefault %.q:BOUND_OBJECT%
Parent topic: Script/Objects Category (DBMS)