There is a sequence with min value 100.
I want to alter this sequence to min value as 101.
If the table has already data in the sequence column as
100,101,102...
Is it possible to do so ?
- 4 Answers
- 10567 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kiran kumar
The START WITH Value can not changed using ALTER SEQUENCE
command. The sequence must be dropped and recreate a
sequence in different number.
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
Does varchar need length?
Is sql similar to python?
How to display the current date in sql?
How does a self join work?
what is a unique key ? : Sql dba
Why do we use triggers?
What view means?
What are the types of subqueries?
What is use of term?
Explain raise_application_error.
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is data types in sql?
What is your daily office routine?
What does desc stand for?
what is a cursor? : Sql dba
