[
https://issues.apache.org/jira/browse/DERBY-6454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dyre Tjeldvoll closed DERBY-6454.
---------------------------------
Verified
> DROP TABLE documentation could clarify how triggers are handled
> ---------------------------------------------------------------
>
> Key: DERBY-6454
> URL: https://issues.apache.org/jira/browse/DERBY-6454
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.10.1.1
> Reporter: Dyre Tjeldvoll
> Assignee: Kim Haase
> Priority: Minor
> Labels: derby_backport_reject_10_10
> Fix For: 10.11.1.1
>
> Attachments: DERBY-6454-2.diff, DERBY-6454.diff, rrefsqlj34148.html,
> rrefsqlj34148.html
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
