Table of Contents

About

A schema is a data resource of a database that contains one or more Sql Object 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 

tabli connection info sqlite

Sample

See Tabulify - Sample Schema