Re: documenting DERBY -783: Enhancements to ALTER TABLE

[Mamta Satoor]

Also, Eric, my change for ALTER TABLE ... RESTART WITH are not checked into the codeline yet (there is a review package pending on the list). I think it will be better if you wait before  submitting a patch for doc changes because it will be good to keep doc in sync with the codeline rather than letting it get ahead of it.

 

Just a thought,

Mamta

 

On 1/18/06, Mamta Satoor <[EMAIL PROTECTED]> wrote:

Actually, the new syntax would leave the ALTER TABLE statement as it is in the documentation. What would change is the definition of column-alteration. It would look as follows

column-Name SET DATA TYPE VARCHAR(integer) |
column-name SET INCREMENT BY integer-constant |column-name RESTART WITH integer-constant
 
And then include information on what this RESTART WITH syntax means for a generated column in the reference guide like you mentioned.
Thanks for looking into documenting this,
Mamta

On 1/18/06, Eric Radzinski <[EMAIL PROTECTED] > wrote:

Can you please confirm or correct my assumption about what is needed to document the enhancements to ALTER TABLE syntax.

 

Is the only change to update the ALTER TABLE syntax in the Reference Guide to include RESTART WITH integer-constant:

 

ALTER TABLE table-Name

{

    ADD COLUMN column-definition |

    ADD CONSTRAINT clause |

    DROP { PRIMARY KEY | FOREIGN KEY constraint-name | UNIQUE

         constraint-name | CHECK constraint-name | CONSTRAINT constraing-name }

   ALTER column-alteration

   LOCKSIZE { ROW | TABLE }

   RESTART WITH integer-constant

}

 

and then to document the behavior of  RESTART W ITH integer-constant within this same reference topic.    Anything else???

---

Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.