tables

The .tables command lists all tables available in the current schema or data source. This is essential for data exploration, query building, and verifying your access to specific tables.

Usage

.tables

When to use

  • Use .tables to discover available tables before writing queries.
  • Helpful for exploring unfamiliar databases, verifying schema changes, or onboarding new users.

Examples

List all tables in the current schema:

.tables

Troubleshooting

  • If no tables are listed, ensure you are connected to the correct schema and have the necessary permissions.
  • Some data sources may require you to set the schema context first.

Demonstration