T-SQL - シーケンスの一覧を取得するクエリ

select
    sc.name as [schema],
    sq.name as [sequence],
    *
from sys.sequences as sq
    inner join sys.schemas sc
        on sq.schema_id = sc.schema_id
order by
    [schema],
    [sequence];

参考

• sys.schemas (Transact-SQL) - SQL Server | Microsoft Learn
• sys.sequences (Transact-SQL) - SQL Server | Microsoft Learn