[
https://issues.apache.org/jira/browse/DERBY-4016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12663849#action_12663849
]
Kim Haase commented on DERBY-4016:
----------------------------------
Thanks, Knut. I suppose we could then modify the statement to say,
"ALTER TABLE syntax
Derby limits somewhat the ALTER TABLE syntax for altering column defaults.
Derby does not support DROP DEFAULT."
Would that be correct?
I haven't yet heard back as to whether SET DEFAULT works with ALTER TABLE ADD
COLUMN as well as ALTER TABLE ALTER COLUMN -- does it?
> 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.
