Chapter 3 DBMS Reference Guide

UddtDefaultName

Default name for a user-defined data type. When a domain has a specific default value defined in its check parameters, Sybase databases create a name as a default value for this user-defined data type.

The corresponding variable is %DEFAULTNAME%

Example

In Sybase Adaptive Server Enterprise 11:

UddtDefaultName = D_%.28:DOMAIN%

The FunctionList domain has a default value defined in its check parameters: Technical Engineer . The following SQL script will generate a default name for that default value:

create default D_FunctionList
as 'Technical Engineer'
go

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