Adding a User-Defined Datatype

Create a user-defined datatype using the Sybase Control Center Administration Console.

1. In the Administration Console, select Server > Schema Objects > User Defined Datatypes.
2. Select New.
   You see the Add User-defined Datatype wizard.
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.