db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1607358 - /db/derby/docs/trunk/src/ref/rrefsqlj81859.dita
Date Wed, 02 Jul 2014 13:09:13 GMT
Author: chaase3
Date: Wed Jul  2 13:09:12 2014
New Revision: 1607358

URL: http://svn.apache.org/r1607358
DERBY-6643  ALTER TABLE columnAlteration syntax needs fixing

Modified a Reference Manual topic.

Patch: DERBY-6643.diff


Modified: db/derby/docs/trunk/src/ref/rrefsqlj81859.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj81859.dita?rev=1607358&r1=1607357&r2=1607358&view=diff
--- db/derby/docs/trunk/src/ref/rrefsqlj81859.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj81859.dita Wed Jul  2 13:09:12 2014
@@ -37,7 +37,8 @@ tables</indexterm><indexterm>Tables<inde
 <li>Add a constraint to a table</li>
 <li>Drop a column from a table</li>
 <li>Drop an existing constraint from a table</li>
-<li>Increase the width of a VARCHAR or VARCHAR FOR BIT DATA column</li>
+<li>Increase the width of a BLOB, CLOB, VARCHAR, or VARCHAR FOR BIT DATA
 <li>Override row-level locking for the table (or drop the override)</li>
 <li>Change the increment value and start value of the identity column</li>
 <li>Change the nullability constraint for a column</li>
@@ -80,8 +81,10 @@ assignable to <i>DataType</i>.</p>
 <p>For details on <varname>defaultConstantExpression</varname>, see 
 <xref href="rrefsqlj30540.dita#rrefsqlj30540/sqlj64478">Column default</xref>.</p></example>
 <example id="rrefsqlj37860"><title>columnAlteration</title>
-<codeblock><b><i>columnName</i> SET DATA TYPE VARCHAR( <i>integer</i>
) |
-<i>columnName</i> SET DATA TYPE VARCHAR FOR BIT DATA( <i>integer</i>
) |
+<codeblock><b><i>columnName</i> SET DATA TYPE BLOB( <i>integer</i>
) |
+<i>columnName</i> SET DATA TYPE CLOB( <i>integer</i> ) |
+<i>columnName</i> SET DATA TYPE VARCHAR( <i>integer</i> ) |
+<i>columnName</i> SET DATA TYPE VARCHAR( <i>integer</i> ) FOR BIT
 <i>columnName</i> SET INCREMENT BY <i>integerConstant</i> |
 <i>columnName</i> RESTART WITH <i>integerConstant</i> |
 <i>columnName</i> [ NOT ] NULL |

View raw message