Chapter 3 DBMS Reference Guide
| Variable name | Comment |
|---|---|
| UNIT | Unit attribute of standard check |
| FORMAT | Format attribute of standard check |
| DATATYPE | Data type. Ex: int, char(10) or numeric(8, 2) |
| DTTPCODE | Data type code. Ex: int, char or numeric |
| LENGTH | Data type length. Ex: 0, 10 or 8 |
| PREC | Data type precision. Ex: 0, 0 or 2 |
| ISRDONLY | TRUE if Read-only attribute of standard check has been selected |
| DEFAULT | Default value |
| MINVAL | Minimum value |
| MAXVAL | Maximum value |
| VALUES | List of values. Ex: (0, 1, 2, 3, 4, 5) |
| LISTVAL | SQL constraint associated with List of values. Ex: C1 in (0, 1, 2, 3, 4, 5) |
| MINMAX | SQL constraint associated with Min and max values. Ex: (C1 <= 0) AND (C1 >= 5) |
| ISMAND | TRUE if Domain or column is mandatory |
| MAND | Contains Keywords "null" or "not null" depending on Mandatory attribute |
| NULL | Contains Keyword "null" if Domain or column is not mandatory |
| NOTNULL | Contains Keyword "not null" if Domain or column is mandatory |
| IDENTITY | Keyword "identity" if Domain or Column is identity (Sybase specific) |
| WITHDEFAULT | Keyword "with default" if Domain or Column is with default |
| ISUPPERVAL | TRUE if the upper-case attribute of standard check has been selected |
| ISLOWERVAL | TRUE if the lower-case attribute of standard check has been selected |
| Copyright (C) 2006. Sybase Inc. All rights reserved. |
| |