[
https://issues.apache.org/jira/browse/DERBY-4016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12664284#action_12664284
]
Kim Haase commented on DERBY-4016:
----------------------------------
Thanks, Dag. So the last line of column-alteration in
http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html will change to
column-name [ WITH | SET ] DEFAULT default-value
(Presumably you can't use both WITH and SET?)
Currently we don't say anything about this clause, but I can add that you can
specify NULL as the default-value to disable a previous default setting. Can
you use NULL if you don't use SET -- that is, can you specify WITH DEFAULT NULL
or just DEFAULT NULL?
> Document syntax change for ALTER TABLE in Reference Manual
> ----------------------------------------------------------
>
> Key: DERBY-4016
> URL: https://issues.apache.org/jira/browse/DERBY-4016
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.5.0.0
> Reporter: Kim Haase
> Assignee: Kim Haase
> Priority: Minor
>
> DERBY-4013 adds support for the standard SET keyword in addition to the
> optional WITH keyword in ALTER TABLE ALTER [COLUMN] statements. This change
> should be documented in the Reference Manual.
> Question: [WITH] DEFAULT occurs also in ALTER TABLE ADD COLUMN. Will SET work
> here as well?
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
