Q) Write the syntax of ‘ALTER SEQUENCE’ statement.

ANS:  Alter Sequence :-

           The ALTER SEQUENCE statement allows to change the Increment, Minimum value, Maximum value, Cached numbers and behaviour of a sequence object.

                                                                 

           Syntax-

 

ALTER SEQUENCE seq_name

  [INCREMENT BY interval]

  [MAXVALUE max_value]

  [MINVALUE min_value]

  [CYCLE | NOCYCLE]

  [CACHE cache_size | NOCACHE]

  [ORDER | NOORDER] ;

·              

             Example-2

 

ALTER SEQUENCE seq_1

  MAXVALUE 1500 ;

 



   
 ALTER SEQUENCE sets a new maximum value

 1500 for the seq_1 sequence.