Le jeudi 26 avril 2007 11:MM, Secrétariat a écrit :
La doc HSQLDB :
Components of a CREATE TABLE command
columnDefinition
columnname Datatype [(columnSize[,precision])]
[{DEFAULT <defaultValue> |
GENERATED BY DEFAULT AS IDENTITY
(START WITH <n>[, INCREMENT BY <m>])}] |
[[NOT] NULL] [IDENTITY] [PRIMARY KEY]
Default values that are allowed are constant values or certain SQL
datetime functions.
Allowed Default Values in Column Definitions
*
For character column, a single-quoted string or NULL. The only SQL
function that can be used is CURRENT_USER.
*
For datetime columns, a single-quoted DATE, TIME or TIMESTAMP value
or NULL. Or a datetime SQL function such as CURRENT_DATE, CURRENT_TIME,
CURRENT_TIMESTAMP, TODAY, NOW. Each function is allowed for a certain
datetime type.
Alex
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
