Domains
A domain is a column definition template, global to the database, upon which actual column definitions in tables may be based.
If there are columns in the database table or in several database tables, having the same properties, it is useful to describe such column type and its behavior as a domain, and then correspond each of these columns to this domain.
|
Create domain |
To create a new domain:
|
Select the Database | New Object menu item. |
|
|
Select Domain in the New Object window. |
|
|
Edit domain properties and fields on the appropriate tabs of the Domain Editor. |
|
Hint: To create new domain you can also right-click the Domains node of the explorer tree and select the New domain... item from the popup menu. |
To create a new domain with the same properties as one of the existing tables has:
|
|
Select the Database | Duplicate Object menu item. |
|
|
Follow the instructions of the Duplicate Object Wizard. |
The Duplicate Object window allows you to select the database to create the new domain in and to edit the result SQL statement for creating the domain.
|
Edit domain |
To edit the existing domain:
|
|
Select the domain for editing in the explorer tree (type the first letters of the domain name for quick search). |
|
|
Right-click and select the Edit domain <Domain_Name> item in the popup menu or simply double-click the domain. |
|
|
Edit domain subobjects and data on the appropriate tabs of the Domain Editor. |
To change the name of the domain:
|
|
Select the domain for editing in the explorer tree. |
|
|
Right-click and select the Rename domain <Domain_Name> item from the popup menu. |
|
|
Edit domain name in the dialog window. |
|
Drop domain |
To drop a domain:
|
|
Select the domain for editing in the explorer tree. |
|
|
Right-click and select the Drop domain <Domain_Name> item from the popup menu. |
|
|
Confirm dropping in the dialog window. |
