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.