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

Provide ALTER TABLE DROP COLUMN functionality

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6
    • 10.3.1.4
    • Documentation, SQL
    • None
    • 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. 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

            People

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

              Dates

                Created:
                Updated:
                Resolved: