Default Values

---

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-value may be replaced by the following construction:

For more information about what can be specified for literal, see Literals.

Standard Compliance

This section summarizes standard compliance concerning the specification of default values.

Standard	Compliance	Comments
SQL-99	Core	Fully compliant.
SQL-99	Features outside core	Feature F555 "Enhanced seconds precision" Localtime and Localtimestamp functions with fractions of seconds.
	Mimer SQL extension	NEXT_VALUE OF and CURRENT_VALUE OF sequences are Mimer SQL extensions.

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se