|
<< Click to Display Table of Contents >> Reserved Words |
  
|
|
<< Click to Display Table of Contents >> Reserved Words |
|
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
__________________________