I am using HSQLDB for my application.
I have already created a table with a primary key.
Now i want to modify it and want to make the primary key column also an Auto incrementing one.
I saw in HSQLDB it can be achieved by the IDENTIY() function.
Could please some one please show me the correct SQL syntax for modifying the DDL for the table?.
Thanks and Regards,
Saurav
Be Objectively Oriented.Explore the power of OOPs.
My Blog, Eclipse EMF Query committer.
Thanks a lot Angelika for the reply.
One more thought on the same lines, could i alter the table definition
because i have already created the table i want to add the identity function
to that.
Be Objectively Oriented.Explore the power of OOPs.
My Blog, Eclipse EMF Query committer.