Main Form Interface > SQL Statements

User defined SQL statements

Via the tabbed SQL area you'll construct or paste your SQL statements to execute.

For saving or loading individual SQL statements or scripts:
see the SQL menu.

SQL types

Standard SQL statements are classified as either:
SQL DDL - Data Definition Language defining the structure of the tables and data fields.
SQL DML - Data Manipulation Language manipulating either extracts or data contents (adding, editing, updating, deleting data), but leaving structure unaltered.

When performing updates by script, e.g. bulk updates - do consider using the TRANSACTION method to help preventing systematic update errors.