SQL DDL Syntax Guide

"DDL" stands for "Data Definition Language". These are the SQL statements that ALTER, CREATE or DROP schema elements in a database.
The Orixa database uses the SQL2003 syntax, which means that on-line guides detailing this syntax can be consulted if you want more information.
There are a number of useful, basic DML statements for Orixa Administrators. Short articles explaining them are added below this page.

Topics Covered

          1. CREATE STORE, DROP STORE, ALTER STORE

          2. CREATE JOB, ALTER JOB, DROP JOB

          3. CREATE FUNCTION, CREATE PROCEDURE

Full SQL Keywords and Functions List

The Orixa SQL Syntax contains many hundreds of keywords and functions which can be called. These are fully listed and described in detailed websites covering SQL2003 Syntax. The Orixa database is built on the ElevateDB database engine, and full details of all keywords and functions can be found at the ElevateDB Website.