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

Provide ALTER TABLE DROP 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
    • 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.

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: