db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4016) Document syntax change for ALTER TABLE in Reference Manual
Date Wed, 14 Jan 2009 10:30:59 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12663716#action_12663716
] 

Knut Anders Hatlen commented on DERBY-4016:
-------------------------------------------

SQL allows this construct, which is still not accepted by Derby, I think:

  ALTER TABLE t ALTER COLUMN c DROP DEFAULT

> 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.


Mime
View raw message