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

Provide ALTER TABLE functionality to change a column's data type

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6
    • Fix Version/s: None
    • Component/s: Documentation, SQL
    • Labels:
      None

      Description

      Derby should provide a feature which allows a user to change the data type of an existing column in an existing table.

      Currently, there exists the statement:

      ALTER TABLE tablename ALTER COLUMN columnname SET DATA TYPE datatype

      However, this statement currently only allows increasing the length of a VARCHAR column. You are not allowed to decrease the width or to change the data type.

      It would be nice if this restriction could be lifted, and the datatype could be changed.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: