Table of Contents

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