[ http://issues.apache.org/jira/browse/DERBY-396?page=comments#action_12374321 ]
Dheeraj Dhiman commented on DERBY-396: -------------------------------------- Hello Scott MacDonald !! I m dheeraj ! I m switch from sql server to apache derby for my project !! You say We can rename or drop a column from table !! But i just try this & exception occur !! My case is :: I just create a table . create table simple( name varchar(100), rollno bigint , fullName varchar(100)); table create after excuting this statement . but now i want to change name of column rollno !! I try ur suggetion which is given by you !! you say :: alter table simple rename column rollno to serialno ; After excuting this query error occur ; ERROR 42X01: Syntax error: Encountered "RENAME" at line 1, column 17. && i m also try another thing if we want drop a column !! alter table simple drop column name ; ERROR 42X01: Syntax error: Encountered "drop" at line 1, column 17 SWo now how can i drop or rename a column in apache derby !! The table simple table have no primary key & no other forignkey !! so how can i do this !! I have mail accoutn on your apache derby jira log . with name dheeraj.dhiman or you can mail me at my email id [EMAIL PROTECTED] I wanna answer of this problem as early as possible !! Thanks !! > 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 > > 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
