db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-1490) Provide ALTER TABLE RENAME COLUMN functionality
Date Tue, 07 Nov 2006 23:12:57 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1490?page=all ]

Bryan Pendleton updated DERBY-1490:

    Attachment: renameColumn_v5_with_schema_test.diff

Attachment renameColumn_v5_with_schema_test.diff differs from the
previous patch proposal only in the addition of a new test that demonstrates
that you can rename a column in a table in the non-current schema by
explicitly specifying a schema name.

That is, the proper syntax for the RENAME COLUMN statement is actually:

  RENAME COLUMN [schema-name.]table-name.column-name TO new-column-name

Thanks Knut Anders for noticing this; I'll fix the documentation in the DERBY-2042 patch.

> 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:,,,,,
>            Reporter: Bryan Pendleton
>         Assigned To: Bryan Pendleton
>         Attachments: 1490_cannot_patch.jpg, derby1490_v1_needMoreTests.diff, renameColumn_v2_with_tests.diff,
renameColumn_v3_after_review.diff, renameColumn_v4_fix_error_message.diff, renameColumn_v5_with_schema_test.diff
> 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


View raw message