Add RESTART [WITH] clause for alter identity columns
----------------------------------------------------

                 Key: CORE-4206
                 URL: http://tracker.firebirdsql.org/browse/CORE-4206
             Project: Firebird Core
          Issue Type: Improvement
          Components: Engine
            Reporter: Adriano dos Santos Fernandes


The full standard syntax is below.

<alter column definition> ::=
    ALTER [ COLUMN ] <column name> <alter column action>

<alter column action> ::=
    <set column default clause>
    | <drop column default clause>
    | <add column scope clause>
    | <drop column scope clause>
    | <alter column data type clause>
    | <alter identity column specification>

<alter identity column specification> ::=
    <alter identity column option>...

<alter identity column option> ::=
    <alter sequence generator restart option>
    | SET <basic sequence generator option>

<alter sequence generator restart option> ::=
    RESTART [ WITH <sequence generator restart value> ]

<basic sequence generator option> ::=
    <sequence generator increment by option>
    | <sequence generator maxvalue option>
    | <sequence generator minvalue option>
    | <sequence generator cycle option>


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to