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]