Derby
  1. Derby
  2. DERBY-1490

Provide ALTER TABLE RENAME COLUMN functionality

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6
    • Fix Version/s: 10.3.1.4
    • Component/s: Documentation, SQL
    • Labels:
      None

      Description

      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.

      1. 1490_cannot_patch.jpg
        65 kB
        Rajesh Kartha
      2. derby1490_v1_needMoreTests.diff
        6 kB
        Bryan Pendleton
      3. renameColumn_v2_with_tests.diff
        38 kB
        Bryan Pendleton
      4. renameColumn_v3_after_review.diff
        22 kB
        Bryan Pendleton
      5. renameColumn_v4_fix_error_message.diff
        22 kB
        Bryan Pendleton
      6. renameColumn_v5_with_schema_test.diff
        24 kB
        Bryan Pendleton

        Issue Links

          Activity

            People

            • Assignee:
              Bryan Pendleton
              Reporter:
              Bryan Pendleton
            • Votes:
              1 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development