[
https://issues.apache.org/jira/browse/DERBY-4016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12664154#action_12664154
]
Dag H. Wanvik commented on DERBY-4016:
--------------------------------------
As far as ADD COLUMN, that uses the normal column definition syntax.
[Section 11.13 in SQL 2003 has the production
<set column default clause> ::= SET <default clause>
which is only ever used by <alter column action>, see section 11.12.]
We still do not support the syntax for DROP DEFAULT, but one can specify SET
DEFAULT NULL
which has the same semantics as dropping the default. We should probably add
this syntax as well. I will
see if I can fit it into DERBY-4013.. Thanks for alerting me.
> 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.
