How to view sequence details with a SQL

To view the DDL of the sequence, use this

select * from information_schema.sequences where sequence_name='<your_sequence_name_in_lower_case>'

If I understand correctly, you can use `INFORMATION_SCHEMA.sequences.

There documentation is here.