Materialize/doc/user/content/sql/show-tables.md

---

title: "SHOW TABLES" description: "SHOW TABLES returns a list of all tables available in Materialize." menu: main:

parent: commands

---

SHOW TABLES returns a list of all tables available in Materialize.

Syntax

SHOW TABLES [FROM <schema_name>]

Details

Output format

SHOW TABLES's output is a table with one column, name.

Examples

Show user-created tables

SHOW TABLES;

 name
----------------
 my_table
 my_other_table

Show tables from specified schema

SHOW SCHEMAS;

  name
--------
 public

SHOW TABLES FROM public;

 name
----------------
 my_table
 my_other_table

Related pages

• SHOW CREATE TABLE
• CREATE TABLE

2025 开源项目分享^© -- 湘ICP备2025131302号

Page: 38ms Template: 1ms Javascript Licenses 关于我们

Option	Description
FROM	If specified, only show tables from the specified schema. Defaults to first resolvable schema in the search path. For available schemas, see SHOW SCHEMAS.