[
https://issues.apache.org/jira/browse/DERBY-4016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12663376#action_12663376
]
Kim Haase commented on DERBY-4016:
----------------------------------
The "Derby and standards" section of the Developer's Guide
(http://db.apache.org/derby/docs/dev/devguide/cdevstandards806118.html)
mentions Derby's implementation of ALTER TABLE:
"ALTER TABLE syntax
Derby uses a slightly different ALTER TABLE syntax for altering column
defaults. While SQL99 uses DROP and SET, Derby uses DEFAULT."
Is our ALTER TABLE syntax now standard, since we now support both DROP and SET?
Should this item be removed?
> 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.
