Submitted by: Derryck welas (welas)

"SQL:standaard " says i can use "default clause" and/or "column constraint " in a column definition.
dont know if this worked before but i'm using FB 2.5.0 at the moment.

example:
CREATE TABLE test (
id BIGINT NOT NULL ,
description VARCHAR(100) NOT NULL DEFAULT 'test',
PRIMARY KEY (id)
);

Error: *** IBPP::SQLException ***
Context: Statement::Prepare( CREATE TABLE test (
id BIGINT NOT NULL ,
description VARCHAR(100) NOT NULL DEFAULT 'test',
PRIMARY KEY (id)
) )
Message: isc_dsql_prepare failed

SQL Message : -104
Invalid token

Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, column 37
DEFAULT

=======
2003 sql ref:
<column definition> ::=
<column name> [ <data type> | <domain name> ] [ <reference scope check> ]
[ <default clause> | <identity column specification> | <generation clause> ]
[ <column constraint definition> ... ] [ <collate clause> ]