SQL reserved words: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Created page with "This topic lists the Model 204 SQL reserved words, which are words that you cannot use as names of SQL objects. This list includes standard and emerging standard SQL reserve...")
 
No edit summary
Line 42: Line 42:
CURRENT_TIMESTAMP <br />
CURRENT_TIMESTAMP <br />
CURSOR</p>
CURSOR</p>
<p>&nbsp;</p>
</td>
</td>


Line 177: Line 176:
USER <br />
USER <br />
<i>USING</i></p>
<i>USING</i></p>
<p>&nbsp;</p>
</td>
</td>


Line 197: Line 195:
</tr>
</tr>
</table>
</table>
[[Category: Model 204 SQL processing]]

Revision as of 17:19, 24 March 2015

This topic lists the Model 204 SQL reserved words, which are words that you cannot use as names of SQL objects.

This list includes standard and emerging standard SQL reserved words and Model 204 SQL proprietary reserved words (in italics).

Model 204 SQL reserved words

ADD
ALL
ALTER
AND
ANY
AS
ASC
AUTHORIZATION

AVG

 

BEGIN
BETWEEN
BLOB
BY

 

CASCADE
CAST
CHAR
CHARACTER
CHECK
CLOB
CLOSE
COBOL
COMMIT
CONTINUE
COUNT
CREATE
CROSS
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURSOR

DEC
DECIMAL
DECLARE
DEFAULT
DELETE
DESC
DISTINCT
DOUBLE
DROP

END
ESCAPE
EXEC
EXISTS

 

FETCH
FLOAT
FOR
FOREIGN
FORTRAN
FOUND
FROM
FULL

 

GO
GOTO
GRANT
GROUP

 

HASH
HAVING

IN
INDEX
INDICATOR
INNER
INSERT
INT
INTEGER
INTO
IS

 

JOIN

 

KEY

 

LANGUAGE
LEFT
LIKE

 

MAX
MIN
MODIFY
MODULE

 

NATURAL
NESTED
NOT
NULL
NUM
NUMERIC

OF
ON
OPEN
OPTION
OR
ORDER
ORDERED
OUTER

 

PASCAL
PLI
POSITIONED
PRECISION
PRIMARY
PRIVILEGES
PROCEDURE
PUBLIC

 

REAL
REFERENCES
RESTRICT
REVOKE
RIGHT
ROLLBACK

SCHEMA
SECTION
SELECT
SET
SMALLINT
SOME
SORT
SQL
SQLCODE
SQLERROR
SQLSTATE
SQLVERSION
SUM
SYSNAME
SYSTEM

 

TABLE
TO
TYPE

 

UNCATALOG
UNION
UNIQUE
UPDATE
USER
USING

VALUES
VIEW

 

WHENEVER
WHERE
WITH
WORK

 

GE
LE
NE