SQL Statements

<< Click to Display Table of Contents >>

Navigation:  Main Form Interface >

SQL Statements

Previous pageReturn to chapter overviewNext page

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.

__________________________
AbsoluteSQL Application Manual - 23 July 2024 - Copyright © 2011 - 2024 Niels Knabe