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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Reference » Using SQL » SQL language elements

 

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