[ http://issues.apache.org/jira/browse/DERBY-1490?page=comments#action_12422455 ] Wolf Benz commented on DERBY-1490: ----------------------------------
Can't both be used? Sorry if this is a stupid question, but can't DB work with aliases? (so that the easier RENAME directive resolves the more formal ALTER... cmd? This way we can all use what we like best. Philippe > 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
