Select from following answers:- To Restart the sequence object, we use the RESTART WITH clause of the Sequence object
- The Restart With value must be an integer and whose range has to be MINVALUE >= RESTART WITH VALUE <=MAXVALUE
- We get the current, maximum and minimum value of the Sequence object from sys.sequences catalog
- All the above
- All Above
To Restart the sequence object, we use the RESTART WITH clause of the Sequence object e.g.
ALTER SEQUENCE dbo.GenerateSequence
RESTART WITH 1;
The Restart With value must be an integer and whose range has to be MINVALUE >= RESTART WITH VALUE <=MAXVALUE
We get the current, maximum and minimum value of the Sequence object from
sys.sequences catalog
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator