r3 - 02 Apr 2008 - 19:08:10 - JulianaImperialYou are here: SuperWaba >  Codev Web  >  ChangeLogs > LitebaseChangelogs > LitebaseReservedWords
Litebase, starting from version 2.0, has reserved words. So, you can not use these words as identifiers.

In the table below you have the reserved words from SQL2003 standard and from Litebase. Many words from SQL2003 standard are not in Litebase reserved words list, but we strongly recommend that you do not use these words, because in a near future they may become a Litebase reserved word.

    SQL Words

    Litebase

    SQL2003

    ABS

    reserved


    ADD

    reserved

    reserved

    ALL


    reserved

    ALLOCATE


    reserved

    ALTER

    reserved

    reserved

    AND

    reserved

    reserved

    ANY


    reserved

    ARE


    reserved

    ARRAY


    reserved

    AS

    reserved

    reserved

    ASC

    reserved


    ASENSITIVE


    reserved

    ASYMMETRIC


    reserved

    AT


    reserved

    ATOMIC


    reserved

    AUTHORIZATION


    reserved

    AVG

    reserved


    BEGIN


    reserved

    BETWEEN


    reserved

    BIGINT


    reserved

    BINARY


    reserved

    BLOB

    reserved

    reserved

    BOOLEAN


    reserved

    BOTH


    reserved

    BY

    reserved

    reserved

    CALL


    reserved

    CALLED


    reserved

    CASCADED


    reserved

    CASE


    reserved

    CAST


    reserved

    CHAR

    reserved

    reserved

    CHARACTER


    reserved

    CHECK


    reserved

    CLOB


    reserved

    CLOSE


    reserved

    COLLATE


    reserved

    COLUMN


    reserved

    COMMIT


    reserved

    CONDITION


    reserved

    CONNECT


    reserved

    CONSTRAINT


    reserved

    CONTINUE


    reserved

    CORRESPONDING


    reserved

    COUNT

    reserved


    CREATE

    reserved

    reserved

    CROSS


    reserved

    CUBE


    reserved

    CURRENT


    reserved

    CURRENT_DATE


    reserved

    CURRENT_DEFAULT_TRANSFORM_GROUP


    reserved

    CURRENT_PATH


    reserved

    CURRENT_ROLE


    reserved

    CURRENT_TIME

    reserved

    CURRENT_TIMESTAMP


    reserved

    CURRENT_TRANSFORM_GROUP_FOR_TYPE


    reserved

    CURRENT_USER


    reserved

    CURSOR


    reserved

    CYCLE


    reserved

    DATE

    reserved

    reserved

    DATETIME

    reserved


    DAY

    reserved

    reserved

    DEALLOCATE


    reserved

    DEC


    reserved

    DECIMAL


    reserved

    DECLARE


    reserved

    DEFAULT

    reserved

    reserved

    DELETE

    reserved

    reserved

    DEREF


    reserved

    DESC

    reserved


    DESCRIBE


    reserved

    DETERMINISTIC


    reserved

    DISCONNECT


    reserved

    DISTINCT


    reserved

    DO


    reserved

    DOMAIN


    reserved

    DOUBLE

    reserved

    reserved

    DROP

    reserved

    reserved

    DYNAMIC


    reserved

    EACH


    reserved

    ELEMENT


    reserved

    ELSE


    reserved

    ELSEIF


    reserved

    END


    reserved

    ESCAPE


    reserved

    EXCEPT


    reserved

    EXEC


    reserved

    EXECUTE


    reserved

    EXISTS


    reserved

    EXIT


    reserved

    EXTERNAL


    reserved

    FALSE


    reserved

    FETCH


    reserved

    FILTER


    reserved

    FLOAT

    reserved

    reserved

    FOR


    reserved

    FOREIGN


    reserved

    FREE


    reserved

    FROM

    reserved

    reserved

    FULL


    reserved

    FUNCTION


    reserved

    GET


    reserved

    GLOBAL


    reserved

    GRANT


    reserved

    GROUP

    reserved

    reserved

    GROUPING


    reserved

    HANDLER


    reserved

    HAVING

    reserved

    reserved

    HOLD


    reserved

    HOUR

    reserved

    reserved

    IDENTITY


    reserved

    IF


    reserved

    IMMEDIATE


    reserved

    IN


    reserved

    INDEX

    reserved


    INDICATOR


    reserved

    INNER


    reserved

    INOUT


    reserved

    INPUT


    reserved

    INSENSITIVE


    reserved

    INSERT

    reserved

    reserved

    INT

    reserved

    reserved

    INTEGER


    reserved

    INTERSECT


    reserved

    INTERVAL


    reserved

    INTO

    reserved

    reserved

    IS

    reserved

    reserved

    ITERATE


    reserved

    JOIN


    reserved

    KEY

    reserved

    reserved

    LANGUAGE


    reserved

    LARGE


    reserved

    LATERAL


    reserved

    LEADING


    reserved

    LEAVE


    reserved

    LEFT


    reserved

    LIKE

    reserved

    reserved

    LOCAL


    reserved

    LOCALTIME


    reserved

    LOCALTIMESTAMP


    reserved

    LONG

    reserved


    LOOP


    reserved

    LOWER

    reserved


    MATCH


    reserved

    MAX

    reserved


    MEMBER


    reserved

    MERGE


    reserved

    METHOD


    reserved

    MILLIS

    reserved


    MIN

    reserved


    MINUTE

    reserved

    reserved

    MODIFIES


    reserved

    MODIFY


    reserved

    MODULE


    reserved

    MONTH

    reserved

    reserved

    NATIONAL


    reserved

    NATURAL


    reserved

    NCHAR


    reserved

    NCLOB


    reserved

    NEW


    reserved

    NO


    reserved

    NOCASE

    reserved


    NONE


    reserved

    NOT

    reserved

    reserved

    NULL

    reserved

    reserved

    NUMERIC


    reserved

    OF


    reserved

    OLD


    reserved

    ON

    reserved

    reserved

    ONLY


    reserved

    OPEN


    reserved

    OR

    reserved

    reserved

    ORDER

    reserved

    reserved

    OUT


    reserved

    OUTER


    reserved

    OUTPUT


    reserved

    OVER


    reserved

    OVERLAPS


    reserved

    PARAMETER


    reserved

    PARTITION


    reserved

    PRECISION


    reserved

    PREPARE


    reserved

    PRIMARY

    reserved

    reserved

    PROCEDURE


    reserved

    RANGE


    reserved

    READS


    reserved

    REAL


    reserved

    RECURSIVE


    reserved

    REF


    reserved

    REFERENCES


    reserved

    REFERENCING


    reserved

    RELEASE


    reserved

    RENAME

    reserved


    REPEAT


    reserved

    RESIGNAL


    reserved

    RESULT


    reserved

    RETURN


    reserved

    RETURNS


    reserved

    REVOKE


    reserved

    RIGHT


    reserved

    ROLLBACK


    reserved

    ROLLUP


    reserved

    ROW


    reserved

    ROWS


    reserved

    SAVEPOINT


    reserved

    SCOPE


    reserved

    SCROLL


    reserved

    SEARCH


    reserved

    SECOND

    reserved

    reserved

    SELECT

    reserved

    reserved

    SENSITIVE


    reserved

    SESSION_USER


    reserved

    SET

    reserved

    reserved

    SHORT

    reserved


    SIGNAL


    reserved

    SIMILAR


    reserved

    SMALLINT


    reserved

    SOME


    reserved

    SUM

    reserved


    SPECIFIC


    reserved

    SPECIFICTYPE


    reserved

    SQL


    reserved

    SQLEXCEPTION


    reserved

    SQLSTATE


    reserved

    SQLWARNING


    reserved

    START


    reserved

    STATIC


    reserved

    SUBMULTISET


    reserved

    SYMMETRIC


    reserved

    SYSTEM


    reserved

    SYSTEM_USER


    reserved

    TABLE

    reserved

    reserved

    TABLESAMPLE


    reserved

    THEN


    reserved

    TIME


    reserved

    TIMESTAMP


    reserved

    TIMEZONE_HOUR


    reserved

    TIMEZONE_MINUTE


    reserved

    TO

    reserved

    reserved

    TRAILING


    reserved

    TRANSLATION


    reserved

    TREAT


    reserved

    TRIGGER


    reserved

    TRUE


    reserved

    UNDO


    reserved

    UNION


    reserved

    UNIQUE


    reserved

    UNKNOWN


    reserved

    UNNEST


    reserved

    UNTIL


    reserved

    UPDATE

    reserved

    reserved

    UPPER

    reserved


    USER


    reserved

    USING


    reserved

    VALUE


    reserved

    VALUES

    reserved

    reserved

    VARCHAR


    reserved

    VARYING


    reserved

    WHEN


    reserved

    WHENEVER


    reserved

    WHERE

    reserved

    reserved

    WHILE


    reserved

    WINDOW


    reserved

    WITH


    reserved

    WITHIN


    reserved

    WITHOUT


    reserved

    WORK


    reserved

    WRITE


    reserved

    YEAR

    reserved