In PostgreSQL one can create a User Defined Type with an implicit CHECK by doing the following:
CREATE DOMAIN OrdinalT AS INTEGER CHECK (value >= 0);
In Sybase ASE 15.7 I've figured that the following is almost equivalent (except for the CHECK):
sp_addtype OrdinalT, "INTEGER";
How do I make a CHECK part of the user-defined type definition in Sybase?