Hi Wendy,
Take a look at http://incubator.apache.org/derby/docs/ref/rrefsqlj24513.html, it has syntax for CREATE TABLE. It talks about how you can have columns with identity attributes for which, Derby automatically assigns increasing integer values. That kind of column type might get you what you are looking for.
Mamta
On 6/13/05, Wendy Gibbons (JIRA) <[email protected]> wrote:
auto sequencing columns
-----------------------
Key: DERBY-351
URL: http://issues.apache.org/jira/browse/DERBY-351
Project: Derby
Type: Bug
Reporter: Wendy Gibbons
I am trying to create a sequence on a derby table, I can not find any of the ways I would normally do this, auto sequencing columns, creating a seperate sequence (and using in the insert)
how am I supposed to implement a sequence please? sorry but I couldn't find a bulletin board or anywhere else to ask for help
--
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
