Restriction: This topic applies to Windows environments only.
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.