Q: alter table to set default column values..

[Prasenjit Sarkar]

Hi,

We are using Derby 10.3.1.4 and are trying to set default column values for
some existing fields in the table.

The original table is:

CREATE TABLE "T_RES_FILESYSTEM"  (
              "FILESYSTEM_ID" INTEGER NOT NULL ,
              "COMPUTER_ID" INTEGER NOT NULL ,
              "GROUP_ID" INTEGER NOT NULL ) ;,


The statement we are trying to use to set default column values is:

ALTER TABLE  T_RES_FILESYSTEM
      ALTER COLUMN GROUP_ID DEFAULT -1 ;


It appears that this is not working. Suggestions welcome,

Regards,

Prasenjit Sarkar