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 2012/05/18 22:33:29 UTC
svn commit: r1340237 - /db/derby/docs/trunk/src/ref/rrefsqlj31580.dita
Author: chaase3
Date: Fri May 18 20:33:29 2012
New Revision: 1340237
URL: http://svn.apache.org/viewvc?rev=1340237&view=rev
Log:
DERBY-5566 CREATE SCHEMA should state that one cannot create a new schema starting with "SYS" in case normal form
Modified a Reference Manual topic.
Patch: DERBY-5566-2.diff
Modified:
db/derby/docs/trunk/src/ref/rrefsqlj31580.dita
Modified: db/derby/docs/trunk/src/ref/rrefsqlj31580.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj31580.dita?rev=1340237&r1=1340236&r2=1340237&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj31580.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj31580.dita Fri May 18 20:33:29 2012
@@ -34,6 +34,8 @@ and provide a unique namespace for objec
</codeblock> <p>The CREATE SCHEMA statement is used to create a schema. A
schema name cannot exceed 128 characters. Schema names must be unique within
the database.</p>
+<p>A schema name cannot start with the prefix SYS (after case normalization).
+Use of the prefix SYS raises a <i>SQLException</i>.</p>
<p>The CREATE SCHEMA statement is subject to access control when the
<codeph><xref href="rrefpropersqlauth.dita#rrefpropersqlauth">derby.database.sqlAuthorization</xref></codeph> property is set to
<codeph>true</codeph> for the database or system. Only the database owner can create a schema with a name