You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by ch...@apache.org on 2014/02/10 16:50:52 UTC
svn commit: r1566663 - /db/derby/docs/trunk/src/ref/rrefsqlj34148.dita
Author: chaase3
Date: Mon Feb 10 15:50:52 2014
New Revision: 1566663
URL: http://svn.apache.org/r1566663
Log:
DERBY-6454 DROP TABLE documentation could clarify how triggers are handled
Modified a Reference Manual topic.
Patch: DERBY-6454-2.diff
Modified:
db/derby/docs/trunk/src/ref/rrefsqlj34148.dita
Modified: db/derby/docs/trunk/src/ref/rrefsqlj34148.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj34148.dita?rev=1566663&r1=1566662&r2=1566663&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj34148.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj34148.dita Mon Feb 10 15:50:52 2014
@@ -28,12 +28,13 @@ limitations under the License.
<section> <p>DROP TABLE removes the specified table.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>DROP TABLE <i><xref href="rreftablename.dita#rreftablename">tableName</xref></i></b></codeblock> </refsyn>
<section id="sqlj38361"><title>Statement dependency system</title> <p>Triggers,
-constraints (primary, unique, check and references from the table being dropped)
-and indexes on the table are silently dropped. The existence of an open cursor
-that references a table being dropped causes the DROP TABLE statement to
-generate an error, and the table is not dropped.</p>
+constraints (primary, unique, check and references from the table being
+dropped), and indexes defined on the table are silently dropped. The existence
+of an open cursor that references a table being dropped causes the DROP TABLE
+statement to generate an error, and the table is not dropped.</p>
<p>The DROP TABLE statement will also generate an error if the table is used in
-a view or trigger.</p>
+a view, or if a trigger defined on another table references the table in its
+trigger action.</p>
<p>Dropping a table invalidates
statements that depend on the table. (Invalidating a statement causes it to
be recompiled upon the next execution. See <xref href="crefsqlj22771.dita#crefsqlj22771"></xref>.)</p> </section>