Querious Docs

Schema Info

The Info subview of Schema Structure shows a schema's definition, what it contains, and how much space it uses.

The Info subview for a MySQL schema

MySQL #

The main pane shows the schema's CREATE DATABASE statement. The sidebar beside it has:

Section Shows
Defaults The default values which affect newly-created tables.
Summary How many tables, views, functions, procedures, and triggers the schema has.
Data Usage Space used by data, by indexes, and in total.

The defaults are the only editable part of this view. The CREATE DATABASE statement, Summary, and Data Usage are read-only.

Default Runs
Character Set, Collation ALTER DATABASE. This changes the default for tables created later, but existing tables keep their own. To change a single table, use Table Info.
Encryption ALTER DATABASE … DEFAULT ENCRYPTION

To change a schema's defaults

  1. Select the schema in the sidebar.
  2. In Defaults, choose a new Character Set, Collation, or Encryption value.
  3. The change runs immediately. There is no Apply button.

PostgreSQL #

Section Shows
Schema Info The Encoding and Collation of the PostgreSQL database the schema is in, and the schema's Owner.
Summary How many tables, views, functions, procedures, triggers, indexes, and types the schema has.
Data Usage Space used by data, by indexes, and in total.

The Comments pane below is the editable part of this view.

To change a schema's comment

  1. Select the schema in the sidebar.
  2. Type in the Comments pane.
  3. Stop typing. Querious saves the comment (COMMENT ON SCHEMA) automatically after a couple of seconds.