Quick Start
Connect to MySQL
HTTP Tunnel
SSH Tunnel
Databases
Schema
Tables
Adding Fields and Choosing Data Types
Customising Fields
Primary Keys and Indexes
Filter Wizard
Foreign Keys
Foreign Keys Data Selection
Uniques and Checks
Rules and Triggers
Privileges
Import/Export
Function
View
Tablespace
Cast
Language
Aggregate
Conversion
Domain
Trigger Function
Operator
Operator Class
Sequence
Type
Queries
Visual Query Builder
Data
Manage Users
Backup
Data Transfer
Schedule
Server Monitor
Data Synchronization
Structure Synchronization
Console
Virtual Grouping
Maintaining your databases/tables
Preferences
General
Tabs
Tables
Queries
  Working with Schema
 
A schema is essentially a namespace: it contains named objects (tables, data types, functions, and operators) whose names may duplicate those of other objects existing in other schemas.

Create a Schema

To create a schema:

  1. Control-click the Database in the Tree View and select New Schema.
  2. Enter Schema properties and fields on the appropriate tabs of the New Schema Editor
  3. Click OK

Design a Schema

To design a schema:

  1. Select the schema you want to design.
  2. Control-click and select the Schema Properties
  3. Edit Schema properties and fields on the appropriate tabs of the Design Schema Editor
  4. Click OK

Delete a Schema

To delete a schema:

  1. Select the schema you want to delete.
  2. Control-click and select Drop Schema
  3. Confirm deleting in the dialog window.