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

DROP TABLE documentation could clarify how triggers are handled

    XMLWordPrintableJSON

Details

    Description

      The description of the DROP TABLE command first asserts that

      "Triggers, constraints (primary, unique, check and references from the table being dropped) and indexes on the table are silently dropped. "

      And then

      "The DROP TABLE statement will also generate an error if the table is used in a view or trigger."

      This is perfectly correct, but I think it would have been easier to grasp if the text had spelled out that triggers which are defined on the table being dropped are dropped automatically, but that the existence of triggers which reference the table being dropped in their trigger action will cause an error.

      Attachments

        1. rrefsqlj34148.html
          5 kB
          Camilla Haase
        2. DERBY-6454.diff
          1 kB
          Camilla Haase
        3. rrefsqlj34148.html
          5 kB
          Camilla Haase
        4. DERBY-6454-2.diff
          2 kB
          Camilla Haase

        Activity

          People

            chaase3 Camilla Haase
            dyret Dyre Tjeldvoll
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: