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-2016 Core Fully compliant. SQL-2016 Features outside core Feature F555, "Enhanced seconds precision". Localtime and Localtimestamp functions with fractions of seconds.Feature T176, "Sequence generator support" Mimer SQL extension Current value for sequences is a Mimer SQL extension.
Mimer Information Technology AB
Phone: +46 18 780 92 00