[ http://issues.apache.org/jira/browse/DERBY-869?page=comments#action_12364133 ]
Mamta A. Satoor commented on DERBY-869: --------------------------------------- Couple of trivial comments 1)At the top of the ALTER TABLE statement page, there are 5 bullet items explaining what alter table statement can be used for (this is before the syntax description). Can you please add that it can be used to change the increment value and start value of the identity column? 2)Please don't include semicolons at the end of the sql statements in the eg for the RESTART WITH. Following sqls have ; at the end. CREATE TABLE tauto(i INT GENERATED BY DEFAULT AS IDENTITY, k INT); CREATE UNIQUE INDEX tautoInd ON tauto(i); INSERT INTO tauto(k) values 1,2; INSERT INTO tauto VALUES (3,3); INSERT INTO tauto VALUES (4,4); INSERT INTO tauto VALUES (5,5); ALTER TABLE tauto ALTER COLUMN i RESTART WITH 6; > documentation to address Derby-783 > ---------------------------------- > > Key: DERBY-869 > URL: http://issues.apache.org/jira/browse/DERBY-869 > Project: Derby > Type: Sub-task > Components: Documentation > Versions: 10.0.2.0 > Reporter: Eric Radzinski > Assignee: Eric Radzinski > Attachments: derby869.diff, rrefsqlj81859.html > > document changes to ALTER TABLE syntax to address Derby-783 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
