The RESTART WITH clause allows the database administrator to
    reset the sequence to a specified value. The value must be
    within the range of MINVALUE and MAXVALUE. This command requires
    exclusive access to the sequence. Once the ALTER SEQUENCE
    statement is successfully committed, applications that use the
    sequence will start with a value based on the restarted value.

                                   NOTE

       The TRUNCATE TABLE statement issued for a table with
       an IDENTITY column implicitly executes an ALTER
       SEQUENCE...RESTART WITH process on the sequence, applying
       the MINVALUE if it is an ascending sequence, or MAXVALUE if
       it is a descending sequence.