Chapter 3 DBMS Resource File Reference

Default

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%

 

Copyright (C) 2008. Sybase Inc. All rights reserved.