Domain compatibility differences exist between SAP Sybase IQ and Adaptive Server and SQL Anywhere.
Named constraints and defaults—In SAP 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 SAP Sybase IQ, you can use either the sp_addtype system procedure or the CREATE DOMAIN statement to add a domain. In Adaptive Server, 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 the ALTER DATATYPE or ALTER ANY OBJECT system privilege and DROP DATATYPE or DROP ANY OBJECT system privileges may not alter or drop domains created using sp_addtype. You must have these system privileges for altering and dropping domains owned by dbo.