cancel
Showing results for 
Search instead for 
Did you mean: 

alter hana sequence

mario_galeano
Participant
0 Kudos
1,606

When trying to re-sequence a sequence I get the following error:

ALTER SEQUENCE "_SYS_SEQUENCE_283138_#0_#" RESTART WITH 1;

Accepted Solutions (1)

Accepted Solutions (1)

pfefferf
Active Contributor
0 Kudos

I guess the sequence is created based on an identity column.

Please check SAP note 2728304 - "ALTER SEQUENCE" command fails with error: "invalid identifier: _sys_ prefix not allowed" ... for more details.

Answers (0)