[ http://issues.apache.org/jira/browse/DERBY-1491?page=comments#action_12420346 ]
Bryan Pendleton commented on DERBY-1491: ---------------------------------------- I think I don't like this syntax. I think that it would be better to provide support for the syntax ALTER TABLE tablename ALTER [COLUMN] columnname SET DEFAULT defaultvalue and ALTER TABLE tablename ALTER [COLUMN] columnname DROP DEFAULT I will revisit this patch and investigate providing this alternate syntax. > Provide ALTER TABLE functionality to change a column's default value > -------------------------------------------------------------------- > > Key: DERBY-1491 > URL: http://issues.apache.org/jira/browse/DERBY-1491 > Project: Derby > Type: New Feature > Components: Documentation, SQL > Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.2.0.0, 10.1.2.1, 10.1.3.0, > 10.1.3.1 > Reporter: Bryan Pendleton > Assignee: Bryan Pendleton > Attachments: modifyDefault_1.diff > > Provide a way to alter the default value for an existing column in an > existing table. The syntax should probably some variant of the ALTER TABLE > statement. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
