SQL Server Sequence Object

Question

While generating script I'm able to select specific database object except Sequence. Is there any way to generate scripts for specific (or) all the available Sequence.

In SSMS you should be able to right-click a sequence in the object explorer and choose 'Script sequence as...' — Zohar Peled
– Zohar Peled, Commented Jan 3, 2017 at 7:42
Thank you. Is there any way to choose all the Sequences available in our DataBase? — Vignesh
– Vignesh, Commented Jan 3, 2017 at 8:44

Zohar Peled · Accepted Answer · 2017-01-03 09:32:10Z

1

In SSMS, press F7 or click view -> object explorer details:

Then select the database, Programmability, Sequences, select all sequences, right click, and choose Script sequence as:

answered Jan 3, 2017 at 9:32

Zohar Peled

82.9k11 gold badges79 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vignesh Over a year ago

Hi @Zohar, Thank you. It is working fine.I will accept this as the correct answer.

Collectives™ on Stack Overflow

SQL Server Sequence Object

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related