db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r732375 - /db/derby/docs/trunk/src/ref/rrefsqlj81859.dita
Date Wed, 07 Jan 2009 15:55:56 GMT
Author: chaase3
Date: Wed Jan  7 07:55:56 2009
New Revision: 732375

URL: http://svn.apache.org/viewvc?rev=732375&view=rev
DERBY-3938: Document that you can change the length of varbinary as well as 
varchar columns

This patch edits the ALTER TABLE topic to add information about changing the 
width of a VARCHAR FOR BIT DATA column.

Patch: DERBY-3938.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=732375&r1=732374&r2=732375&view=diff
--- db/derby/docs/trunk/src/ref/rrefsqlj81859.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj81859.dita Wed Jan  7 07:55:56 2009
@@ -36,7 +36,7 @@
 <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, CHAR VARYING, and CHARACTER VARYING column</li>
+<li>increase the width of a VARCHAR or VARCHAR FOR BIT DATA column</li>
 <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>
@@ -59,6 +59,7 @@
 <p>For details on <varname>DefaultConstantExpression</varname>, see 
 <xref href="rrefsqlj30540.dita#sqlj64478">Column default</xref>.</p></example>
 <example id="rrefsqlj37860"><title>column-alteration</title><codeblock><b><i>column-Name</i>
+<i>column-Name</i> SET DATA TYPE VARCHAR FOR BIT DATA(integer) |
 <i>column-name</i> SET INCREMENT BY integer-constant |
 <i>column-name</i> RESTART WITH integer-constant |
 <i>column-name</i> [ NOT ] NULL |
@@ -156,7 +157,7 @@
 as a <i>backing index</i>).</p></section>
 <section><title>Modifying columns</title><p>The <i><xref
 you to alter the named column in the following ways:   <ul>
-<li>Increasing the length of an existing VARCHAR column. CHARACTER VARYING
+<li>Increasing the width of an existing VARCHAR or VARCHAR FOR BIT DATA column. CHARACTER
 or CHAR VARYING can be used as synonyms for the VARCHAR keyword. <p>To increase
 the width of a column of these types, specify the data type and new size after
 the column name.</p><p>You are not allowed to decrease the width or to change

View raw message