Select from following answers:- ALTER SEQUENCE [dbo].[SequenceObj] RESTART
- ALTER SEQUENCE [dbo].[SequenceObj] RESTART WITH 1
- EXECUTE [dbo].[sp_sequence_restart] ‘SequenceObj’, 1
- Option 1 and 2
- All Above
If the WITH clause is not included with the RESTART, the sequence numbering restarts based on the original CREATE SEQUENCE options.Since the data type specified is TINYINT, the sequence number will start with 0 if WITH is not included with the RESTART clause.
So first option is not valid....
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator