About
A schema is a container data resource of a database that contains one or more Sql Data Resources such as tables or view
URI
The Data URI that defines a schema has the following form:
# Fully Qualified
catalog.schema.@connection
# With the catalog of the connection if any
schema.@connection
# The default schema of the connection
@connection
where:
- connection is the connection name
- schema is the schema name
- catalog is the catalog name
It has the same form as a SQL path form where the object name is the empty string.
How to see the default schema of a connection ?
You can see the default schema of your connection with the connection info command.
This is the value set in the working path
tabul connection info sqlite
Sample
See Sample Schema