Thursday 13 February 2014

Alter Sequence




In Vertica, using 'Alter' Command we can reset the sequence number, we can rename sequence Name and we can change Schema.

Reset Sequence number:
         ALTER SEQUENCE <Sequence Name> RESTART WITH 200

Rename Sequence:
         ALTER SEQUENCE <Schema Name>.<Sequence Name> TO <New Sequence name>

Change Schema:
         ALTER SEQUENCE <Schema Name>.<Sequence Name> SET SCHEMA <New Schema Name>

No comments:

Post a Comment