Chapter 3 DBMS Reference Guide
| Variable | 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) 2007. Sybase Inc. All rights reserved. |
| |