Data Resource - SQL Schema

Undraw Environment

Data Resource - SQL Schema

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 Tabulify - Sample Schema




Related HowTo
Undraw Environment
How to install the World MySQL Sample Schema

This howto will show you how to install the world sample schema of MySQL. The installation is done with the sql script world.sql This script is idempotent...
Undraw Environment
Learning Tabulify - Step 2 - What's a Data Resource ?

The first job of a data processing platform such as Tabulify is to work with data. Tabulify calls, locates and knows all data uniformly under the term Data Resource. A file is a data resource A directory...
Undraw Environment
Tabulify - How to fill a database relational schema with generated data and Tabul

This how-to will show you how to use the tabul fill command to fill all the tables of a schema with generated data.
Undraw Environment
Tabulify - How to select data resources with a Glob Pattern

With this howto, you will learn what a glob pattern is and how to use it to select data resources.

Task Runner