Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > CREATE TABLE >

Using a Literal as a Default Value

You can designate a literal value as a default value. A literal value is a string of alphabetic or numeric characters. To use a literal value as a default value, you must adhere to the syntax restrictions in the following table.

For Columns of Data Type Format of Default Value
BOOLEAN Use 't' or 'f' (respectively for true or false) as a Quoted String, p. Quoted String.
CHAR, CHARACTER VARYING, DATE, VARCHAR, NCHAR, NVARCHAR, LVARCHAR
Quoted String, p. Quoted String.
See note that follows for DATE.
DATETIME Literal DATETIME, p. Literal DATETIME
DECIMAL, MONEY, FLOAT, SMALLFLOAT Literal Number, p. Literal Number
INTEGER, SMALLINT, DECIMAL, MONEY, FLOAT, SMALLFLOAT, INT8 Literal Number, p. Literal Number
INTERVAL Literal INTERVAL, p. Literal INTERVAL
Opaque data types (IDS) Quoted String, p. Quoted String in Single-Column Constraint format (p. Single-Column Constraint Format)

DATE literals must be of the format that the DBDATE (or else GL_DATE) environment variable specifies. In the default locale, if neither DBDATE nor GL_DATE is set, date literals must be of the mm/dd/yyyy format.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]