Chapter 3 DBMS Reference Guide

UddtRuleName

Name of a rule defined for a user-defined data type. When a domain has a specific rule defined in its check parameters, the Sybase database creates a name for this user-defined data type value for a rule.

The corresponding variable is %RULE%

Example

In Sybase Adaptive Server Enterprise 11:

UddtRuleName = R_%.28:DOMAIN%

The Domain_speciality domain has to belong to a set of values. This domain check has been defined in a validation rule. The SQL script will generate the rule name following the template defined in the entry UddtRuleName :

create rule R_Domain_speciality
as 
    (@Domain_speciality in ('Industry','Military','Nuclear','Bank','Marketing'))
go

execute sp_bindrule R_Domain_speciality, T_Domain_speciality
go

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