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 rh...@apache.org on 2017/09/12 00:06:58 UTC

svn commit: r1808072 - /db/derby/docs/trunk/src/ref/rrefsqlj81859.dita

Author: rhillegas
Date: Tue Sep 12 00:06:58 2017
New Revision: 1808072

URL: http://svn.apache.org/viewvc?rev=1808072&view=rev
Log:
DERBY-6959: Doc changes for required SET keyword when changing the cycling behavior of identity columns; commit derby-6959-02-aa-setCycleDocs.diff.

Modified:
    db/derby/docs/trunk/src/ref/rrefsqlj81859.dita

Modified: db/derby/docs/trunk/src/ref/rrefsqlj81859.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj81859.dita?rev=1808072&r1=1808071&r2=1808072&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj81859.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj81859.dita Tue Sep 12 00:06:58 2017
@@ -78,7 +78,7 @@ href="rrefconstraintname.dita#rrefconstr
 <i>columnName</i> { SET | DROP } NOT NULL |
 <i>columnName</i> [ NOT ] NULL |
 <i>columnName</i> [ WITH | SET ] DEFAULT <i>defaultValue</i> |
-<i>columnName</i> [ NO ] CYCLE |
+<i>columnName</i> SET [ NO ] CYCLE |
 <i>columnName</i> DROP DEFAULT</b> </codeblock></example>
 <section><p>In the <i>columnAlteration</i>, SET INCREMENT BY <i>integerConstant</i> specifies
 the interval between consecutive values of the identity column. The next value
@@ -313,7 +313,7 @@ ALTER TABLE Employees ALTER COLUMN Salar
 ALTER TABLE Employees ALTER COLUMN Salary DROP DEFAULT
 
 <ph>-- Enable CYCLE behavior for the message_id column</ph>
-ALTER TABLE messages ALTER COLUMN message_id CYCLE
+ALTER TABLE messages ALTER COLUMN message_id SET CYCLE
 
 <ph>-- Bulk load a table by temporarily changing a GENERATED ALWAYS identity column
 -- into a GENERATED BY default column.