Extend ALTER SEQUENCE syntax with SELECT
----------------------------------------

                 Key: CORE-5621
                 URL: http://tracker.firebirdsql.org/browse/CORE-5621
             Project: Firebird Core
          Issue Type: New Feature
    Affects Versions: 3.0.2
         Environment: any
            Reporter: Tommi Prami
            Priority: Minor


ALTER SEQUENCE <name> RESTART WITH (SELECT MAX(ID) FROM CUSTOMER);

Sometimes the select is not that start forward, but anyways would do good to be 
able to fetch new value with select,

Would make easier to reset the Sequences in some scenarios like when you have 
to enter data to db by hand etc (Like in development phase) or when there is an 
bug in software.

-- 
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

        

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to