[Solved] Alter Table Field

[capemayal1]

HSQLDB 2.0

Table = Table1

Fields= ID (primary key) Not autovalue; myname (VARCHAR) length = 50

I am unable to change any parameter of any field, example, can not change ID to autovalue = Yes from autovalue = No.

For the text field, I am unable to change the the length from 50 to 100 or from 50 to a lower number.

I must delete the field, and establish the field again, and ensure that I have selected the parameters.

Then, I must re-enter all the field's values.

Is there a solution to this?

Thank you.
Al

[Sliderule]

Since this is for HSQL 2.0 ( NOT for HSQL 1.8 as in OpenOffice default Version 3.3 and prior ):

1. From the Menu: Tools -> SQL...
2. In the Command to execute box, enter:
   

   Code: Select all

   ALTER TABLE "Table1" ALTER COLUMN "ID" GENERATED ALWAYS AS IDENTITY;
   
   ALTER TABLE "Table1" ALTER COLUMN "myname" VARCHAR(100);
   

3. Press the Execute button
4. Press the Close button
5. From the Menu: View -> Refresh Tables

I hope this helps, please be su8re to let me / us know.

Sliderule

Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.

[DACM]

HSQLDB 2.0...I am unable to change any parameter of any field...Is there a solution to this?

Other properties may have SQL- or GUI-based workarounds as well. See the following link for details:
The Frozen 'Field Property' Workaround (when using Base to create/adjust Table structures; applies to all external databases).

You may find other database management tools useful in this role as well.
.