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

Remove confusing statement "If there is an index defined on the table, the table can be renamed."

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3.2.1
    • Fix Version/s: 10.6.1.0
    • Component/s: Documentation
    • Labels:
      None
    • Environment:
      N/A
    • Urgency:
      Normal

      Description

      Remove following restriction for "RENAME TABLE" statement:

      "If there is an index defined on the table, the table can be renamed."

      I really do not see any valid reasons (except, probably not very wise implementation) for existence this restriction. And it may come very inconvinient if table to be renamed has an index(ses) referenced by foreign keys from other tables.

      Regards,
      Oleksandr

        Attachments

        1. docs.diff
          0.9 kB
          Bryan Pendleton
        2. rrefsqljrenametablestatement.html
          4 kB
          Bryan Pendleton

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: