Listing all sequences in a SQL Server database

Question

I tried:

SELECT * 
FROM sys.sequences

I get:

Error: The "variant" data type is not supported.
SQLState: 08S01
ErrorCode: 0

I know there are sequences. Is there a way to see sequences of a table in SQL Server Management Studio in the GUI somehow? Thanks.

EDIT: I noticed that this doesn't work with SQL Squirrel client program but the very same query can be used succesfully in SQL Server Management Studio.

Answer 1

You can find sequences in SSMS in object explorer under Programmability:

Answer 2

If you want to know the sequences and values, you can cast the variant types. For example the following will give most of the details you may be looking for:

SELECT
  name,
  cast(start_value AS NUMERIC)   AS start_value,
  cast(increment AS NUMERIC)     AS increment,
  cast(current_value AS NUMERIC) AS current_value
FROM sys.sequences;