This keyword provides column and table information including metadata such as commit lag and max uncommitted row count. The SHOW keyword is useful for checking if tables contain a designated timestamp column.

:::info

These commands return the tables and columns as a table. If you would like to query your tables and columns with filters or to use the results as part of a function, see table_columns() and tables() functions.

:::

Examples

Show all tables:

SHOW TABLES;

Show all columns for table my_table

SHOW COLUMNS FROM my_table;