SQL Command Category Overview

Standard SQL statements supported by the XDB Server can be divided into three functional command categories:

• Data Definition Language (DDL) statements create, alter and drop relational database objects such as databases, tables and indexes.
• Data Manipulation Language (DML) statements select, update, insert, and delete data values within relational database tables.
• Data Control Language (DCL) statements establish system security by controlling access to data objects, plus regulating concurrency and transaction processing.

In addition, there are utility commands (that perform administrative functions on the XDB Server) and embedded and dynamic SQL commands.