db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1489) Provide ALTER TABLE DROP COLUMN functionality
Date Fri, 14 Jul 2006 18:39:14 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1489?page=comments#action_12421188 ] 
            
Daniel John Debrunner commented on DERBY-1489:
----------------------------------------------

Bryan wrote:
----
2) DROP COLUMN needs to automatically revoke any privileges granted on the column. We need
some code in the dropColumnFromTable() method in AlterTableConstantAction which looks for
privileges granted on this column, and if there are any, automatically revoke those privileges.

----
That should also be driven by the dependency system. A grant privilege on a column should
be dependent on the column.
When the column is dropped it fires off a invalidation event  and the privilege should drop
itself .




> Provide ALTER TABLE DROP COLUMN functionality
> ---------------------------------------------
>
>                 Key: DERBY-1489
>                 URL: http://issues.apache.org/jira/browse/DERBY-1489
>             Project: Derby
>          Issue Type: New Feature
>          Components: Documentation, SQL
>    Affects 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
>         Assigned To: 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