Total Pageviews

2016/05/08

How to Get All Sequences in SQL Server

Problem
If I would like to get all sequences in Microsoft SQL Server, how to do it?


How-To
You can use this SQL statement to retrieve all sequences information as follows:
1
SELECT * FROM SYS.SEQUENCES;



Reference
[1] http://stackoverflow.com/questions/19035941/how-can-i-determine-if-a-sequence-exist-in-sql-server-2012

No comments: