Adding a User-Defined Datatype

Name and design your own datatypes to supplement system datatypes.

  1. In the Administration Console, select Server > Schema Objects > User Defined Datatypes.
  2. Select New.
  3. On the Introduction screen, select the server and database in which to create the datatype, and the datatype owner.
  4. On the User-Defined Datatype Name screen, enter the name of the datatype.
  5. On the System Datatype screen, select the system datatype that the user-defined datatype is based on, and whether the datatype allows null or identity values.
    Depending on the system datatype, specify the size for your user-defined datatype.
  6. On the Options screen, bind the datatype to a rule or default. Select In Future Only if you do not want existing columns to acquire the new rule or default.
  7. (Optional) Click Summary to view your selected options.