<< Click to Display Table of Contents >>
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.
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.__________________________