db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dheeraj Dhiman (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-396) Support for ALTER STATEMENT to DROP , MODIFY, RENAME a COLUMN
Date Thu, 13 Apr 2006 10:05:09 GMT
    [ 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 
dheeraj.dhiman@gmail.com

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


Mime
View raw message