Adding a User-Defined Datatype

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

1. In the Administration Console view, 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. Also select the datatype owner.
4. On the User Defined Datatype Name screen, enter the name of the datatype you want to create.
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, you may also have to specify the size for your user-defined datatype.
6. On the Options screen, you can 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 see the database options you have selected.