iMega's Blog This notebook

SQL 89

SQL was initially developed at IBM by Donald D. Chamberlin and Raymond F. Boyce in the early 1970s. This version, initially called SEQUEL (Structured English Query Language), was designed to manipulate and retrieve data stored in IBM’s original quasi-relational database management system, System R, which a group at IBM San Jose Research Laboratory had developed during the 1970s. The acronym SEQUEL was later changed to SQL because “SEQUEL” was a trademark of the UK-based Hawker Siddeley aircraft company.

Reserved Words

ADD          DATE       INDEX      NULL         TABLE
ALL          DECIMAL    INNER      ON           TIME
ALTER        DELETE     INSERT     OR           TIMESTAMP
AND          DESC       INTEGER    ORDER        UNIQUE
ASC          DISALLOW   INTERVAL   PRIMARY      UPDATE
Avg          DISTINCT   INTO       REAL         VALUES
BETWEEN      DROP       IS         REFERENCES   Var
BIT          FLOAT      JOIN       RIGHT        VarP
BY           FOREIGN    KEY        SELECT       WHERE
CHARACTER    FROM       LEFT       SET          WITH
COLUMN       GROUP      LIKE       SMALLINT
CONSTRAINT   HAVING     Max        StDev
Count        IGNORE     Min        StDevP
CREATE       IN         NOT        Sum
iMega's Blog
iMega logo