Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11208 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 form and report?
Explain how to use transactions efficiently : transact sql
What does select top 1 do in sql?
What is sqlite format?
How to return an array from java to pl/sql?
Why use stored procedures?
How do I view a procedure in sql?
How to pipe multiline string to isql?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is meaning of <> in sql?
What are pl sql procedures?
What is varchar example?
What is recursive stored procedure?
Is sql port 1433 encrypted?
How can you tell the difference between an index and a view?
