Sybase IQ supports the following default values for columns:
A string specified in the CREATE TABLE statement or ALTER TABLE statement
A number specified in the CREATE TABLE statement or ALTER TABLE statement
An automatically incremented number: one more than the previous highest value in the column
UUID (Universally Unique IDentifier) values generated by the NEWID function
The current date, time, or timestamp
The name of the current database
The current user ID of the database user and the name of the user who last modified the row
The publisher user ID of the database for SQL Remote applications
A NULL value
A constant expression, as long as it does not reference database objects
A supported default value specified in a user-defined domain (data type) using the CREATE DOMAIN statement