Creating a Domain

Use the Create Domain wizard to create an SAP Sybase IQ domain.

Prerequisites
Database Version Domain Privileges
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • RESOURCE authority
SAP Sybase IQ 16.0 You must have one of:
  • CREATE DATATYPE system privilege
  • CREATE ANY OBJECT system privilege
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Schema Objects, and then select Domains.
  3. Click the arrow next to Domain and select New.
    The Create Domain Wizard appears.
  4. On the Welcome page, specify
    Option Description
    Select a resource for which the domain will be created From the list, select the resource for which the domain will be created.
    What do you want to name the domain? Enter a unique name for the new domain; maximum of 128 characters.
    Which built-in type do you want to use? From the list, select the domain type. Specify the size, scale and unit when enabled for specify types.
    Note: For appropriate data type options and default values, in the SAP Sybase IQ documentation, see Reference: Building Blocks, Tables, and Procedures > SQL Data Types.
  5. Click Next.
  6. On the Clauses page, specify
    Option Description
    This domain has a default value Select to define a default value.
    Null values Select whether null values will be allowed. Default is to use the database default setting, which allows null values.
  7. Click Next.
  8. On the Check Constraint page, specify a check constraint for the domain.
  9. Click Finish.
Parent topic: Domains
Related tasks
Deleting a Domain
Generating Domain DDL Commands
Viewing Domain Properties
Authenticating a Login Account for a Managed Resource
Related reference
Domain Privilege Summary