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_v8_restored_tests.diff
        60 kB
        Bryan Pendleton
      2. drop_column_v7_suggestions_from_mamta.diff
        23 kB
        Bryan Pendleton
      3. drop_column_v6_grant_not_implemented.diff
        36 kB
        Bryan Pendleton
      4. drop_column_v5_grant_tests.diff
        30 kB
        Bryan Pendleton
      5. dropColumn_v4_grant_tests.diff
        31 kB
        Bryan Pendleton
      6. dropColumn_v3_view_drop.diff
        30 kB
        Bryan Pendleton
      7. dropColumn_2.diff
        27 kB
        Bryan Pendleton

        Issue Links

          Activity

          Bryan Pendleton created issue -
          Bryan Pendleton made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-396 [ DERBY-396 ]
          Bryan Pendleton made changes -
          Link This issue relates to DERBY-726 [ DERBY-726 ]
          Bryan Pendleton made changes -
          Link This issue relates to DERBY-165 [ DERBY-165 ]
          Bryan Pendleton made changes -
          Attachment dropColumn_2.diff [ 12336531 ]
          Rick Hillegas made changes -
          Urgency Normal
          Bryan Pendleton made changes -
          Derby Info [Patch Available]
          Bryan Pendleton made changes -
          Derby Info [Patch Available]
          Bryan Pendleton made changes -
          Fix Version/s 10.2.0.0 [ 11187 ]
          Bryan Pendleton made changes -
          Link This issue is blocked by DERBY-1754 [ DERBY-1754 ]
          Bryan Pendleton made changes -
          Link This issue is blocked by DERBY-1583 [ DERBY-1583 ]
          Bryan Pendleton made changes -
          Attachment dropColumn_v3_view_drop.diff [ 12339641 ]
          Bryan Pendleton made changes -
          Attachment dropColumn_v4_grant_tests.diff [ 12340164 ]
          Bryan Pendleton made changes -
          Attachment drop_column_v5_grant_tests.diff [ 12340533 ]
          Bryan Pendleton made changes -
          Link This issue is related to DERBY-1854 [ DERBY-1854 ]
          Bryan Pendleton made changes -
          Link This issue is related to DERBY-1847 [ DERBY-1847 ]
          Bryan Pendleton made changes -
          Link This issue is blocked by DERBY-1847 [ DERBY-1847 ]
          Bryan Pendleton made changes -
          Bryan Pendleton made changes -
          Derby Info [Patch Available]
          Bryan Pendleton made changes -
          Link This issue relates to DERBY-1909 [ DERBY-1909 ]
          Bryan Pendleton made changes -
          Bryan Pendleton made changes -
          Attachment drop_column_v8_restored_tests.diff [ 12342050 ]
          Bryan Pendleton made changes -
          Link This issue is depended upon by DERBY-1926 [ DERBY-1926 ]
          Bryan Pendleton made changes -
          Resolution Fixed [ 1 ]
          Derby Info [Patch Available]
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 10.3.0.0 [ 12310800 ]
          Andrew McIntyre made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Dag H. Wanvik made changes -
          Link This issue relates to DERBY-3940 [ DERBY-3940 ]
          Dag H. Wanvik made changes -
          Issue Type New Feature [ 2 ] Improvement [ 4 ]
          Gavin made changes -
          Workflow jira [ 12375067 ] Default workflow, editable Closed status [ 12801416 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development