SQL Reserved Words
The following cannot be used in any SQL statement.
Click here to download a PDF of this page.
|
|
ABSOLUTE |
ACTION |
ADD |
ALL |
|
ALLOCATE |
ALTER |
AND |
ANY |
ARE |
|
AS |
ASC |
ASSERTION |
AT |
AUTHORIZATION |
|
AVG |
BEGIN |
BETWEEN |
BIT |
BIT_LENGTH |
|
BOTH |
BY |
CASCADE |
CASE |
CAST |
|
CATALOG |
CHAR |
CHARACTER |
CHARACTER_LENGTH |
CHAR_LENGTH |
|
CHECK |
CLOSE |
COALESCE |
COLLATE |
COMMIT |
|
CONNECT |
CONNECTION |
CONSTRAINT |
CONSTRAINTS |
CONTINUE |
|
CONVERT |
CORRESPONDING |
COUNT |
CREATE |
CROSS |
|
CURRENT |
CURRENT_DATE |
CURRENT_TIME |
CURRENT_TIMESSTAMP |
CURRENT_USER |
|
CURSOR |
DATE |
DEALLOCATE |
DEC |
DECIMAL |
|
DECLARE |
DEFAULT |
DEFERRABLE |
DEFERRED |
DELETE |
|
DESC |
DESCRIBE |
DESCRIPTOR |
DIAGNOSTICS |
DISCONNECT |
|
DISTINCT |
DOMAIN |
DOUBLE |
DROP |
ELSE |
|
END |
ENDEXEC |
ESCAPE |
EXCEPT |
EXCEPTION |
|
EXEC |
EXECUTE |
EXISTS |
EXTERNAL |
EXTRACT |
|
FALSE |
FETCH |
FILE |
FIRST |
FLOAT |
|
FOR |
FOREIGN |
FOUND |
FROM |
FULL |
|
GET |
GLOBAL |
GO |
GOTO |
GRANT |
|
GROUP |
HAVING |
HOUR |
IDENTITY |
IMMEDIATE |
|
IN |
INDICATOR |
INITIALLY |
INNER |
INPUT |
|
INSENSITIVE |
INSERT |
INT |
INTEGER |
INTERSECT |
|
INTERVAL |
in |
IS |
ISOLATION |
JOIN |
|
KEY |
LANGUAGE |
LAST |
LEADING |
LEFT |
|
LEVEL |
LIKE |
LOCAL |
LOWER |
MATCH |
|
MAX |
MIN |
MINUTE |
MODULE |
NAMES |
|
NATIONAL |
NATURAL |
NCHAR |
NEXT |
NO |
|
NOT |
NULL |
NULLIF |
NUMERIC |
OCTET_LENGTH |
|
OF |
ON |
ONLY |
OPEN |
OPTION |
|
OR |
ORDER |
OUTER |
OUTPUT |
OVERLAPS |
|
PAD |
PARTIAL |
POSITION |
PREPARE |
PRESERVE |
|
PRIMARY |
PRIOR |
PRIVILEGES |
PROCEDURE |
PUBLIC |
|
READ |
REAL |
REFERENCES |
RELATIVE |
RESTRICT |
|
REVOKE |
RIGHT |
ROLE |
ROLLBACK |
ROWS |
|
SCHEMA |
SCROLL |
SECOND |
SECTION |
SELECT |
|
SESSION_USER |
SET |
SIZE |
SMALLINT |
SOME |
|
SPACE |
SQL |
SQLCODE |
SQLERROR |
SQLSTATE |
|
SUBSTRING |
SUM |
SYSTEM_USER |
TABLE |
TEMPORARY |
|
THEN |
TIME |
TIMESTAMP |
TIMEZONE_HOUR |
TIMEZONE_MINUTE |
|
TO |
TRAILING |
TRANSACTION |
TRANSLATE |
TRANSLATION |
|
TRIM |
TRUE |
UNION |
UNIQUE |
UNKNOWN |
|
UPDATE |
UPPER |
USAGE |
USER |
USING |
|
VALUE |
VALUES |
VARCHAR |
VARYING |
WHEN |
|
WHENEVER |
WHERE |
WITH |
WORK |
WRITE |
|
YEAR |
ZONE |
|
|
|
Netsmart reserved words
|
FACILITY |
PATID |
STAFFID, STAFF_ID |
EPISODE |
DATAENTRYDATE DATA_ENTRY_DATE |
|
DATAENTRYTIME DATA_ENTRY_TIME |
DATAENTRYBYLOGIN DATA_ENTRY_BY_LOGIN |
DATAENTRYBYOPTION |
|
|
