Syntax\n------\n\nSHOW CREATE SEQUENCE sequence_name;\n\nDescription\n-----------\n\nShows the CREATE SEQUENCE statement that creates the given sequence. The statement requires the SELECT privilege for the table.\n\nSHOW CREATE SEQUENCE quotes identifiers according to the value of the sql_quote_show_create system variable.\n\nExamples\n--------\n\nCREATE SEQUENCE s1 START WITH 50;\nSHOW CREATE SEQUENCE s1\\G;\n************************ 1. row ************************\n       Table: s1\nCreate Table: CREATE SEQUENCE s1 start with 50 minvalue 1 maxvalue 9223372036854775806 \n  increment by 1 cache 1000 nocycle ENGINE=InnoDB\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-sequence