Setting Standard Check Parameters for Objects in a Data Model

Standard parameters indicate common data constraints. The following table lists standard parameters:

Parameter

Description

Minimum

Lowest acceptable numeric value

Maximum

Highest acceptable numeric value

Default

Value selected from a list of default values or typed in the listbox. The list of values is defined in the Script\Keywords\ReservedDefault entry of the DBMS definition file

Format

Data format (for example, 9999.99)

Unit

Standard measure

Lowercase

Forces all alphabetical characters to lowercase

Uppercase

Forces all alphabetical characters to uppercase

Cannot Modify

Protects from changes, results in a non-modifiable column/entity attribute in the table when generated in the database

List of Values

Authorized values

Label

String that identifies an authorized value in the list

For more information on defaults, see Defaults (PDM).

  1. Open the property sheet of a domain or column/entity attribute and click the Standard Checks tab.

  2. Enter the appropriate standard parameters, and then click OK.

See also Managing quotation marks around values (PDM).


Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com