Displays tables and columns available in the database.

:::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 all_tables() functions.

:::

Examples

Show all tables:

SHOW TABLES;

Show all columns for table weather

SHOW COLUMNS FROM myTable;