db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1489) Provide ALTER TABLE DROP COLUMN functionality
Date Sat, 08 Jul 2006 16:21:30 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1489?page=all ]

Bryan Pendleton updated DERBY-1489:
-----------------------------------

    Attachment: dropColumn_2.diff

Attachment dropColumn_2.diff continues the work done in DERBY-396's dropColumn_1.diff by adding
a number of additional tests, and by modifying the db2Compatibility test.

With this diff, derbyall passes cleanly.

Feedback about the compiler changes in this diff would be wonderful, as would feedback about
additional test cases to add.

> Provide ALTER TABLE DROP COLUMN functionality
> ---------------------------------------------
>
>          Key: DERBY-1489
>          URL: http://issues.apache.org/jira/browse/DERBY-1489
>      Project: Derby
>         Type: New Feature

>   Components: Documentation, SQL
>     Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.2.0.0, 10.1.2.1, 10.1.3.0, 10.1.3.1
>     Reporter: Bryan Pendleton
>     Assignee: Bryan Pendleton
>      Fix For: 10.2.0.0
>  Attachments: dropColumn_2.diff
>
> Provide a way to drop a column from an existing table. Possible syntax would be:
>   ALTER TABLE tablename DROP COLUMN columnname CASCADE / RESTRICT;
> Feature should properly handle columns which are used in constraints, views, triggers,
indexes, etc.

-- 
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