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,
Be Objectively Oriented.Explore the power of OOPs.
My Blog, Eclipse EMF Query committer.