Chapter 3 DBMS Reference Guide

ColnDefaultName

Name of Default for Column. When a column has a specific default value defined in its check parameters, a name is created for this column default value. This entry is used with DBMS that do not support check parameters on columns such as SQL Server 4.

The corresponding variable is %DEFAULTNAME%

Example

In Sybase Adaptive Server Enterprise 11:

ColnDefaultName = D_%.19:COLUMN%_%.8:TABLE% 

The column Employee function EMPFUNC of the table EMPLOYEE has the default value, Technical Engineer. The column default name, D_EMPFUNC_EMPLOYEE , is created:

create default D_EMPFUNC_EMPLOYEE
as 'Technical Engineer'
go

execute sp_bindefault D_EMPFUNC_EMPLOYEE, "EMPLOYEE.EMPFUNC"
go

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