docs: missing documentation for SHOW_SEQUENCES table function

Open Beginner friendly
#3,185 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
1/5
Estimated time
1-3 hours
Newbie friendliness
82/100
Issue type
Documentation
Clarity
Clearly specified
Activity status
Quiet
Tech stack
sql
Domain
documentation

Research direction

Read the implementation at src/query/service/src/table_functions/show_sequences/show_sequences_table.rs and its registration in src/query/service/src/table_functions/table_function_factory.rs. Create docs/en/sql-reference/20-sql-functions/17-table-functions/show-sequences.md covering the listed output columns and the SELECT * FROM show_sequences() example; done means the missing documentation page is complete.

Written by the indexing model from the issue text.

Description

documentation

Missing Documentation: show_sequences Table Function

What is missing

The show_sequences table function is implemented in the Databend source code but has no documentation page in databend-docs.

Source code location

src/query/service/src/table_functions/show_sequences/show_sequences_table.rs

Also registered in the table function factory at:
src/query/service/src/table_functions/table_function_factory.rs

What it does

show_sequences() returns a list of all sequences defined in the current tenant/catalog. It is the table-function equivalent of the SHOW SEQUENCES SQL statement and can be used in queries, CTEs, and subqueries.

Output schema:

  • name (String) — sequence name
  • interval (Int64) — auto-increment step interval
  • current (UInt64) — current value of the sequence
  • created_on (Timestamp) — creation timestamp
  • updated_on (Timestamp) — last updated timestamp
  • comment (String, nullable) — optional comment

Example usage:

SELECT * FROM show_sequences();
Suggested doc location

docs/en/sql-reference/20-sql-functions/17-table-functions/show-sequences.md

Dominant language
TypeScript
Stars
17
Forks
44
Avg merge
2d 7m
Merged PRs (30d)
4

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from databendlabs/databend-docs

All issues in databendlabs/databend-docs

Similar issues

More TypeScript issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.