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

Provide ALTER TABLE functionality to change a column from NULL to NOT NULL or vice versa

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6
    • None
    • Documentation, SQL
    • None

    Description

      Allow an existing column in an existing table to be changed from NULL to NOT NULL, or vice versa. Probably the syntax for this should be some variant on the ALTER TABLE statement.

      Attachments

        1. alterColumnNotNull_1.diff
          8 kB
          Bryan Pendleton

        Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-396 Support for ALTER STATEMENT to DROP , MODIFY, RENAME a COLUMN

          • Major - Major loss of function.
          • Closed
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-396 Support for ALTER STATEMENT to DROP , MODIFY, RENAME a COLUMN

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: