[ http://issues.apache.org/jira/browse/DERBY-1490?page=comments#action_12422215 ] Edson Richter commented on DERBY-1490: --------------------------------------
There is additional syntax that could be interesting (from SapDB): To rename a column: RENAME tableName.columnName to newColumnName This syntax is very clear and easy to use (but could cause confusion for people searching for an "ALTER...RENAME" thing. If Derby team wish to maintain "ALTER TABLE ... ALTER COLUMN", then the sintax could be: ALTER TABLE tableName ALTER COLUMN columnName RENAME TO newColumnName > Provide ALTER TABLE RENAME COLUMN functionality > ----------------------------------------------- > > Key: DERBY-1490 > URL: http://issues.apache.org/jira/browse/DERBY-1490 > Project: Derby > Issue Type: New Feature > Components: Documentation, SQL > Affects 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 > > Provide a way to rename a column in an existing table. Possible syntax could > be: > ALTER TABLE tablename RENAME COLUMN oldcolumn TO newcolumn; > Feature should properly handle the possibility that the column is currently > used in constraints, views, indexes, triggers, etc. -- 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
