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
- 10577 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ranvijay
we can only alter MINVALUE,MAXVALYE,Incremented by and
CACHE of sequence.but not alter START WITH.
Alter sequence sequanceName
incremented by 2
minvalue 101;
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
what is sql server agent? : Sql dba
Is pl sql useful?
What is schema in sql example?
What are the built in functions of sql?
How would you reference column values before and after you have inserted and deleted triggers?
Can we use views in stored procedure?
What is integrity in sql?
What is the difference between truncate and drop statements?
What are the types of optimization?
what is the different between now() and current_date()? : Sql dba
What are sql queries used for?
What is meant by temporal data?
What are the advantages of indexing?
Is a foreign key always unique?
Does sap use sql?
