I am not aware of a way to modify a default value in Derby. You can add
a default at the table creation time, but not sure if you can add a
default to an existing column.
Bernd Ruehlicke wrote:
Hmm - scary silence followed this e-mail.
To clarify the mail.
I want to be able to modify a default value for a column.
Anybody know what is supported in Derby and what isn't ?
From: Bernd Ruehlicke [mailto:BRuehlicke@lgc.com]
Sent: Monday, January 17, 2005 1:12 PM
To: Derby Discussion
Subject: Add a default to an existing column ?
Hmm - the documentation states that you can add a default
value to an existing column in
l#HDRSII-SQLJ-21322 but I cannot find any syntax which works for me.
1) What is the syntax if I want to add a default value to a column ?
2) What is the syntax if I want to modify a default value of
a colum ? (Is this possible at all ?)