There are various places in the Mimer SQL syntax where a default value can be specified. The value resulting from a default value specification must always be assignment-compatible with the data type of the context to which it will be applied.
In the syntax diagrams, the term
default-valuemay be replaced by the following construction:
For more information about what can be specified for
literal, see Literals.
This section summarizes standard compliance concerning the specification of default values.
SQL-2011 Core Fully compliant. SQL-2011 Features outside core Feature T176, "Sequence generator support"Feature F555, "Enhanced seconds precision". Localtime and Localtimestamp functions with fractions of seconds. Mimer SQL extension Current value for sequences is a Mimer SQL extension.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40