Words to Avoid
The following table lists common keywords from the SQL-92 and SQL-99 ANSI standards. While Pervasive.SQL may not support or offer all of these keywords, you should avoid using these words as names for tables, columns, or other objects, if you do not use double-quotes around them. Pervasive reserves the right to add support for any of these keywords as well as any future ANSI SQL keywords in future releases.
If you use double-quotes to delimit all table, column, and user-defined object names, you do not need to worry about possible future conflicts with reserved words.
See also the previous section, Reserved Words .
Table B-1 Words to Avoid as User-Defined Names
| ABSOLUTE |
ACTION |
ADD |
| ALL |
ALLOCATE |
ALTER |
| AND |
ANY |
ARE |
| AS |
ASC |
ASSERTION |
| AT |
AUTHORIZATION |
AVG |
| BEGIN |
BETWEEN |
BIT |
| BIT_LENGTH |
BOTH |
BY |
| CASCADE |
CASCADED |
CASE |
| CAST |
CATALOG |
CHAR |
| CHARACTER |
CHAR_LENGTH |
CHARACTER_LENGTH |
| CHECK |
CLOSE |
COALESCE |
| COLLATE |
COLLATION |
COLUMN |
| COMMIT |
CONNECT |
CONNECTION |
| CONSTRAINT |
CONSTRAINTS |
CONTINUE |
| CONVERT |
CORRESPONDING |
COUNT |
| CREATE |
CROSS |
CURRENT |
| CURRENT_DATE |
CURRENT_TIME |
CURRENT_TIMESTAMP |
| CURRENT_USER |
CURSOR |
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 |
| EXTERNAL |
EXTRACT |
FALSE |
| FETCH |
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 |
INTO |
| IS |
ISOLATION |
JOIN |
| KEY |
LANGUAGE |
LAST |
| LEADING |
LEFT |
LEVEL |
| LIKE |
LOCAL |
LOWER |
| MASK |
MATCH |
MAX |
| MIN |
MINUTE |
MODULE |
| MONTH |
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 |
PRECISION |
PREPARE |
| PRESERVE |
PRIMARY |
PRIOR |
| PRIVILEGES |
PROCEDURE |
PUBLIC |
| READ |
REAL |
REFERENCES |
| RELATIVE |
RESTRICT |
REVOKE |
| RIGHT |
ROLLBACK |
ROWS |
| SCHEMA |
SCROLL |
SECOND |
| SECTION |
SELECT |
SESSION |
| 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 |
| VIEW |
WHEN |
WHENEVER |
| WHERE |
WITH |
WORK |
| WRITE |
YEAR |
ZONE |
