[ http://issues.apache.org/jira/browse/DDLUTILS-11?page=all ]
Thomas Dudziak updated DDLUTILS-11:
-----------------------------------
Component: Core - Derby/Cloudscape/JavaDB
> derby create table syntax
> -------------------------
>
> Key: DDLUTILS-11
> URL: http://issues.apache.org/jira/browse/DDLUTILS-11
> Project: DdlUtils
> Type: Bug
> Components: Core - Derby/Cloudscape/JavaDB
> Environment: apache derby 10.1.1.0
> Reporter: dan meany
> Assignee: Thomas Dudziak
>
> Create table syntax for AUTOINCREMENT column and DEFAULT value should be:
> CREATE TABLE TEST (
> SEQ_NO INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START
> WITH 1, INCREMENT BY 1),
> STATUS CHAR(1) NOT NULL DEFAULT 'Y',
> PRIMARY KEY (SEQ_NO)
> );
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
