• Product Information
  • About
  • News
  • Screenshots
• Support Information
  • Documentation
  • FAQ
  • Support
• Download
• Purchase

Download Buy

ASA Maestro online Help

Domain Editor

Domain Editor is opened automatically after a new Domain is created and is available on editing the existing one (see Edit Domain for details).
 

The basic principles of Object Editors in ASA Maestro are considered in the corresponding topic. See below to find the description of editor tabs that are unique to the current object.

Domain Editor provides you with an ability to edit Domain properties. The Properties tab allows you to change the Domain name, the Domain owner, etc.

Name

Here you can view and edit the Domain name. The name of the Domain must be unique among all the Domain names in the schema.

Data type

Select the underlying SQL data type for the domain.

Not Null

The checkbox indicates that the values of the Domain are not allowed to be null.

Default value

Set the value to be used as the value for the column in any INSERT statement that does not specify a value for the column.

Check expression

When creating an expression, you can use a variable name prefixed with the @ sign in the expression. When the data type is used in the definition of a column, such a variable is replaced by the column name. This allows Check conditions to be defined on data types and used by columns of any name.

To apply the changes, select the Apply Changes item in the Navigation bar or use Ctrl+F9 or Ctrl+F7 shortcut keys.

It is also possible to modify object properties without opening the object editor: use the Object Properties item of the popup menu of the selected object from the explorer tree.