Reserved Words

<< Click to Display Table of Contents >>

Navigation:  Appendix >

Reserved Words

Previous pageReturn to chapter overview

 

The words reserved in SQL of the Absolute Database are listed below.

If you use a reserved word for table name, column or index name, you must enclose the name in square brackets to use it in any SQL statement.

ABS

ABSOLUTE

ACOS

ACTION

ADD

ALL

ALLOCATE

ALTER

AND

ANY

ARE

AS

ASC

ASIN

ASSERTION

AT

ATAN

AUTHORIZATION

AUTOINC

AUTOINDEXES

AVG

BEGIN

BETWEEN

BIT

BIT_LENGTH

BLOBBLOCKSIZE

BLOBCOMPRESSIONALGORITHM

BLOBCOMPRESSIONMODE

BOTH

BY

CASCADE

CASCADED

CASE

CAST

CATALOG

CEIL

CHAR

CHAR_LENGTH

CHARACTER

CHARACTER_LENGTH

CHECK

CLOSE

COALESCE

COLLATE

COLLATION

COLUMN

COMMIT

CONNECT

CONNECTION

CONSTRAINT

CONSTRAINTS

CONTINUE

CONVERT

CORRESPONDING

COS

COUNT

CREATE

CROSS

CURRENT

CURRENT_DATE

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_USER

CURSOR

CYCLED

DATE

DAY

DEALLOCATE

DEC

DECIMAL

DECLARE

DEFAULT

DEFERRABLE

DEFERRED

DELETE

DESC

DESCRIBE

DESCRIPTOR

DIAGNOSTICS

DISCONNECT

DISTINCT

DOMAIN

DOUBLE

DROP

ELSE

END

END-EXEC

ESCAPE

EXCEPT

EXCEPTION

EXEC

EXECUTE

EXISTS

EXP

EXTERNAL

EXTRACT

FALSE

FETCH

FIRST

FLOAT

FLOOR

FLUSH

FOR

FOREIGN

FOUND

FROM

FULL

GET

GLOBAL

GO

GOTO

GRANT

GROUP

HAVING

HOUR

IDENTITY

IF

IMMEDIATE

IN

INCREMENT

INDEX

INDICATOR

INITIALLY

INITIALVALUE

INNER

INPUT

INSENSITIVE

INSERT

INT

INTEGER

INTERSECT

INTERVAL

INTO

IS

ISOLATION

JOIN

KEY

LANGUAGE

LAST

LASTAUTOINC

LASTVALUE

LEADING

LEFT

LENGTH

LEVEL

LIKE

LOCAL

LOG

LOWER

LTRIM

MATCH

MAX

MAXVALUE

MEMORY

MIMETOBIN

MIN

MINUS

MINUTE

MINVALUE

MODIFY

MODULE

MONTH

NAMES

NATIONAL

NATURAL

NCHAR

NEW

NEXT

NO

NOAUTOINDEXES

NOCASE

NOCYCLED

NOMAXVALUE

NOMINVALUE

NOT

NOW

NULL

NULLIF

NUMERIC

OCTET_LENGTH

OF

ON

ONLY

OPEN

OPTION

OR

ORDER

OUTER

OUTPUT

OVERLAPS

PAD

PARTIAL

PASSWORD

POS

POSITION

POWER

PRECISION

PREPARE

PRESERVE

PRIMARY

PRIOR

PRIVILEGES

PROCEDURE

PUBLIC

RAND

READ

REAL

REFERENCES

RELATIVE

RENAME

RESTRICT

REVOKE

RIGHT

ROLLBACK

ROUND

ROWNUM

ROWS

RTRIM

SCHEMA

SCROLL

SECOND

SECTION

SELECT

SESSION

SESSION_USER

SET

SIGN

SIN

SIZE

SMALLINT

SOME

SPACE

SQL

SQLCODE

SQLERROR

SQLSTATE

SQR

SQRT

START

SUBSTRING

SUM

SYSDATE

SYSTEM_USER

TABLE

TEMPORARY

THEN

TIME

TIMESTAMP

TIMEZONE_HOUR

TIMEZONE_MINUTE

TO

TODATE

TOP

TOSTRING

TRAILING

TRANSACTION

TRANSLATE

TRANSLATION

TRIM

TRUE

TRUNCATE

UNION

UNIQUE

UNKNOWN

UPDATE

UPPER

USAGE

USER

USING

VALUE

VALUES

VARCHAR

VARYING

VIEW

WHEN

WHENEVER

WHERE

WITH

WORK

WRITE

YEAR

ZONE

__________________________
Absolute SQL Reference - 25 May 2022, Niels Knabe