Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1490

Provide ALTER TABLE RENAME COLUMN functionality

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: 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.

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: