[ http://issues.apache.org/jira/browse/DERBY-396?page=comments#action_12357069 ]
Satheesh Bandaram commented on DERBY-396: ----------------------------------------- SQL standard specifies DROP COLUMN syntax as: ALTER TABLE <table name> DROP [COLUMN ]<column name><drop behavior> <drop behavior>::= CASCADE | RESTRICT You have to define if you are implementing CASCADE or RESTRICT behavior. Restrict would be easier to implement. About RENAME COLUMN, it is not defined in the SQL standard. Derby typically allows SQL conforming syntax, so not sure about this one... > Support for ALTER STATEMENT to DROP , MODIFY, RENAME a COLUMN > -------------------------------------------------------------- > > Key: DERBY-396 > URL: http://issues.apache.org/jira/browse/DERBY-396 > Project: Derby > Type: New Feature > Components: SQL > Environment: LINUX > Reporter: Kumar Matcha > Assignee: Scott MacDonald > Priority: Critical > > Alter Statement should support dropping a column, modifying a column to a > different data type , rename a column. -- 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
