Derby
  1. Derby
  2. DERBY-1489

Provide ALTER TABLE DROP 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
    • Urgency:
      Normal

      Description

      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.

      1. drop_column_v5_grant_tests.diff
        30 kB
        Bryan Pendleton
      2. drop_column_v6_grant_not_implemented.diff
        36 kB
        Bryan Pendleton
      3. drop_column_v7_suggestions_from_mamta.diff
        23 kB
        Bryan Pendleton
      4. drop_column_v8_restored_tests.diff
        60 kB
        Bryan Pendleton
      5. dropColumn_2.diff
        27 kB
        Bryan Pendleton
      6. dropColumn_v3_view_drop.diff
        30 kB
        Bryan Pendleton
      7. dropColumn_v4_grant_tests.diff
        31 kB
        Bryan Pendleton

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development