Issue Details (XML | Word | Printable)

Key: CORE-4206
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Adriano dos Santos Fernandes
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Add RESTART [WITH] clause for alter identity columns

Created: 04/Sep/13 03:59 PM   Updated: 29/May/15 03:23 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 3.0 Alpha 2

Issue Links:
Replace
 

QA Status: Done successfully


 Description  « Hide
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>


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.