[ http://issues.apache.org/jira/browse/DERBY-1491?page=all ]
Bryan Pendleton updated DERBY-1491: ----------------------------------- Attachment: modifyDefault_1.diff Attached is modifyDefault_1.diff, a patch proposal to support the statement ALTER TABLE tablename MODIFY COLUMN columnname DEFAULT defaultvalue; The keyword COLUMN is optional. There aren't very many tests in this patch yet; I intend to write more tests. > 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