Chapter 3 DBMS Reference Guide
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. |