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
I wanna answer of this problem as early as possible !!