Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Language Elements

Explicit selectivity estimates Next Page

Special values


Special values can be used in expressions, and as column defaults when creating tables.

While some special values can be queried, some can only be used as default values for columns. For example, user, last user, timestamp and UTC timestamp can only be used as default values.


CURRENT DATABASE special value
CURRENT DATE special value
CURRENT PUBLISHER special value
CURRENT TIME special value
CURRENT TIMESTAMP special value
CURRENT USER special value
CURRENT UTC TIMESTAMP special value
LAST USER special value
SQLCODE special value
SQLSTATE special value
TIMESTAMP special value
USER special value
UTC TIMESTAMP special value