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.