db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1339595 - /db/derby/docs/trunk/src/ref/rrefsqlj61102.dita
Date Thu, 17 May 2012 13:29:37 GMT
Author: chaase3
Date: Thu May 17 13:29:36 2012
New Revision: 1339595

URL: http://svn.apache.org/viewvc?rev=1339595&view=rev
DERBY-5591  Imprecise wording in documentation in ref man on DROP VIEW

Modified a Reference Manual topic.

Patch: DERBY-5591.diff


Modified: db/derby/docs/trunk/src/ref/rrefsqlj61102.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj61102.dita?rev=1339595&r1=1339594&r2=1339595&view=diff
--- db/derby/docs/trunk/src/ref/rrefsqlj61102.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj61102.dita Thu May 17 13:29:36 2012
@@ -31,8 +31,15 @@ limitations under the License.
 <codeblock><b>DROP VIEW AnIdentifier</b></codeblock> </example>
 <section><title>Statement dependency system</title> <p>Any statements
 referencing the view are invalidated on a DROP VIEW statement. DROP VIEW is
-disallowed if there are any views or open cursors dependent on the view. The
-view must be dropped before any objects that it is dependent on can be dropped.</p>
+disallowed if there are any views or open cursors dependent on the view.</p>
+<p>Normally, you must drop a view before you drop any objects that the view
+depends on. However, if you issue an ALTER TABLE DROP COLUMN command with the
+CASCADE option, any views that depend on the column will be dropped. Also, if
+you use a REVOKE statement to revoke privileges on objects that a view depends
+on, the view will be dropped. Similarly, if you use a DROP ROLE statement to
+drop a role that has privileges on objects that a view depends on, the view will
+be dropped.</p>

View raw message