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