Table of Contents

Design Goals & Basic Usage

How to connect to a server and execute SQL statements.

Table Editor & Database Scope

How to create and edit table structures for multiple identical databases.

DML Dialog

How to generate UPDATEs, INSERTS, or DELETEs for an existing row in a table.

Code Snippets

How to save and edit snippets of SQL code that you can reuse.

Procedure Code Editor

How to save and edit procedures, functions, triggers, and views.

Index Editor

How to create and edit indices.

User Manager

How to manage users, as well as add and delete permissions.

Foreign Key Editor

How to create and edit foreign key constraints.

Other Tasks

How to create batch tasks and some miscellaneous statements.

Compare Schemas

How to compare two databases and generate DDL to make them identical.

Global Find

How to build a query to find text in any database or table.

Import File

How to load a delimited file (including CSV) into an existing or new table.

Export Results

How to export query results to CSV, JSON, or XML format.

Generate PHP Web Site

How to generate a simple PHP Web Site.

Generate Import Script

How to generate a simple script to load delimited files.

Support

How to get help using Forward Curves Data Tool.