Domain compatibility differences exist between Sybase IQ and Adaptive Server Enterprise and SQL Anywhere.
Named constraints and defaults—In Sybase IQ, user-defined data types are created with a base data type, and optionally, a NULL or NOT NULL condition. Named constraints and named defaults are not supported.
Creating data types—In Sybase IQ, you can use either the sp_addtype system procedure or the CREATE DOMAIN statement to add a domain. In Adaptive Server Enterprise, you must use sp_addtype. The owner of the sp_addtype and other stored procedures inherited from SQL Anywhere is dbo. The creator for any object created using SQL Anywhere stored procedure is also dbo, and thus a user without DBA authority may not alter or drop domains created using sp_addtype. You must have DBA authority to alter or drop domains created with CREATE DOMAIN.