db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Prasenjit Sarkar <psar...@almaden.ibm.com>
Subject Q: alter table to set default column values..
Date Tue, 16 Oct 2007 17:29:17 GMT
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




Mime
View raw message