db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-396) Support for ALTER STATEMENT to DROP , MODIFY, RENAME a COLUMN
Date Tue, 08 Nov 2005 20:29:22 GMT
    [ 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


Mime
View raw message