db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edson Richter (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1490) Provide ALTER TABLE RENAME COLUMN functionality
Date Wed, 19 Jul 2006 18:07:14 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1490?page=comments#action_12422215 ] 
            
Edson Richter commented on DERBY-1490:
--------------------------------------

There is additional syntax that could be interesting (from SapDB):
To rename a column:

RENAME tableName.columnName to newColumnName

This syntax is very clear and easy to use (but could cause confusion for people searching
for an "ALTER...RENAME" thing.

If Derby team wish to maintain "ALTER TABLE ... ALTER COLUMN", then the sintax could be:

ALTER TABLE tableName ALTER COLUMN columnName RENAME TO newColumnName



> Provide ALTER TABLE RENAME COLUMN functionality
> -----------------------------------------------
>
>                 Key: DERBY-1490
>                 URL: http://issues.apache.org/jira/browse/DERBY-1490
>             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
>
> Provide a way to rename a column in an existing table. Possible syntax could be:
>   ALTER TABLE tablename RENAME COLUMN oldcolumn TO newcolumn;
> Feature should properly handle the possibility that the column is currently used in constraints,
views, indexes, triggers, 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