SQL Commands

4D - Documentation   Français   English   German   Japanese   4D SQL Reference, Table of Contents   4D SQL Reference, Index   Back   Previous   Next

version 11.3 (Modified)


SQL commands (or statements) are generally grouped into two categories:

Data Manipulation Commands, which are used to obtain, add, remove and/or modify database information. More specifically, this refers to the SELECT, INSERT, UPDATE and DELETE commands.

Data Definition Commands, which are used to create or remove database objects. More specifically, this refers to the CREATE TABLE, ALTER TABLE, DROP INDEX, DROP TABLE or CREATE SCHEMA commands.

In the syntax, command names and keywords appear in bold and are passed "as is." Other elements appear in italics and are detailed separately in the "Syntax rules" theme.


4D - Documentation   Français   English   German   Japanese   4D SQL Reference, Table of Contents   4D SQL Reference, Index   Back   Previous   Next