Chapter 3 DBMS Reference Guide

Bind

Command for binding a default object to a domain or a column.

When a domain or a column use a default object, the default object is not added but 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 dropdown listbox, then the default value is declared in the column creation line:

ADDRESS      char(10)          default 'StdAddress' null

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