Precedence of rules  After defining a rule

Chapter 13: Defining Defaults and Rules for Data

Rules and NULL values

You cannot define a column to allow nulls, and then override this definition with a rule that prohibits null values. For example, if a column definition specifies NULL and the rule specifies the following, an implicit or explicit NULL does not violate the rule:

@val in (1,2,3)

The column definition overrides the rule, even a rule that specifies:

@val is not null




Copyright © 2005. Sybase Inc. All rights reserved. After defining a rule

View this book as PDF