eXtremeSQL processes SQL statements of two types: Data Definition Language (DDL) and Data Manipulation Language (DML).
DDL Statements
DDL statements add, modify and remove tables and indexes to or from the eXtremeSQL Metatable which manages all SQL access. Please use the following links to view the syntax for and examples of the Data Definition Language statements:
create table Create a table; add this table definition to the eXtremeSQL Metatable alter table Modify the definition of an existing table drop table Remove an existing table from the eXtremeSQL Metatable create index Create an index on an existing table drop index Remove an existing index from the eXtremeSQL Metatable create synonym Create a synonym, which is an alternative name (or alias) for a table drop synonym Remove an existing synonym DML Statements
DML statements add, modify or remove rows from or perform queries on existing tables. Please use the following links to view the syntax for and examples of the Data Manipulation Language statements:
insert Insert a row into an existing table update Modify an existing row in a table delete Remove an existing row from a table truncate Delete all rows from the table select Perform a query on one or more tables backup Perform an incremental backup for an eXtremeDB database