schemas

The .schemas command lists all schemas available in the connected data source. Schemas are logical containers for tables, views, and other database objects, and are especially important in multi-tenant or enterprise databases.

Usage

.schemas

When to use

  • Use .schemas to discover available schemas when connecting to complex databases.
  • Helpful for exploring unfamiliar data sources, organizing queries, or verifying access permissions.

Examples

List all schemas in the current data source:

.schemas

Troubleshooting

  • If no schemas are listed, ensure your connection has the necessary permissions.
  • Some databases may not support schemas; in that case, this command may return an empty result.

Demonstration