[jira] [Commented] (TRAFODION-1994) enable alter table support change column default value

["liu ming (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-1994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15283833#comment-15283833 ] 

liu ming commented on TRAFODION-1994:
-------------------------------------

Sometimes after table created, one want to change the table column definition to have different default value. 
It will be good to have this implemented.

create table altert3 (c1 int, c2 int, c3 int);
alter table altert3 alter column c3 default 1;
--set the default value of column c3 to 1




> enable alter table support change column default value
> ------------------------------------------------------
>
>                 Key: TRAFODION-1994
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1994
>             Project: Apache Trafodion
>          Issue Type: Improvement
>          Components: sql-cmu
>            Reporter: liu ming
>            Assignee: liu ming
>             Fix For: 2.1-incubating
>
>
> Enhance the 'ALTER TABLE' DDL to support change column DEFAULT setting



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)