These words are reserved in either Cirro or the SQL-92 standard and should not be used as identifier names.

Reserved Words

Begins With Words
A ADD, ALL, ALLOCATE, ALTER, AND, ANY, ARE, AS, ASC, ASSERTION, AT, AUTHORIZATION, AVG
B BEGIN, BETWEEN, BIGINT, BIT, BOOLEAN, BOTH, BY
C CALL, CASCADE, CASCADED, CASE, CAST, CHAR, CHARACTER, CHECK, CLOSE, COALESCE, COLLATE, COLLATION, COLUMN, COMMIT, CONNECT, CONNECTION, CONSTRAINT, CONSTRAINTS, CONTINUE, CONVERT, CORRESPONDING, CREATE, CROSS, CURRENT, CURRENT_DATE, CURRENT_ROLE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, CURSOR
D DEALLOCATE, DEC, DECIMAL, DECLARE, DEFAULT, DEFERRABLE, DEFERRED, DELETE, DESC, DESCRIBE, DIAGNOSTICS, DISCONNECT, DISTINCT, DOUBLE, DROP
E ELSE, END , END-EXEC , ESCAPE , EXCEPT ,EXCEPTION ,EXEC ,EXECUTE ,EXISTS ,EXPLAIN ,EXTERNAL
F FALSE, FETCH, FIRST, FLOAT, FOR, FOREIGN, FOUND, FROM, FULL, FUNCTION
G GET, GETCURRENTCONNECTION, GLOBAL, GO, GOTO, GRANT, GROUP
H HAVING, HOUR
I IDENTITY, IMMEDIATE, IN, INDICATOR, INITIALLY, INNER, INOUT, INPUT, INSENSITIVE, INSERT, INT, INTEGER, INTERSECT, INTO, IS, ISOLATION
J JOIN
K KEY
L LAST, LEFT, LIKE, LOWER, LTRIM
M MATCH, MAX, MIN, MINUTE
N NATIONAL, NATURAL, NCHAR, NVARCHAR, NEXT, NO, NONE, NOT, NULL, NULLIF, NUMERIC
O OF, ON, ONLY, OPEN, OPTION, OR, ORDER, OUTER, OUTPUT, OVER, OVERLAPS
P PAD, PARTIAL, PREPARE, PRESERVE, PRIMARY, PRIOR, PRIVILEGES, PROCEDURE, PUBLIC
R READ, REAL, REFERENCES, RELATIVE, RESTRICT, REVOKE, RIGHT, ROLLBACK, ROWS, ROW_NUMBER, RTRIM
S SCHEMA, SCROLL, SECOND, SELECT, SESSION_USER, SET, SMALLINT, SOME, SPACE, SQL, SQLCODE, SQLERROR, SQLSTATE, SUBSTR, SUBSTRING, SUM, SYSTEM_USER
T TABLE, TEMPORARY, TIMEZONE_HOUR, TIMEZONE_MINUTE, TO, TRANSACTION, TRANSLATE, TRANSLATION, TRIM, TRUE
U UNION, UNIQUE, UNKNOWN, UPDATE, UPPER, USER, USING
V VALUES, VARCHAR, VARYING, VIEW
W WHENEVER, WHERE, WITH, WORK, WRITE
X XML, XMLEXISTS, XMLPARSE, XMLQUERY, XMLSERIALIZE
Y YEAR

Additional Information

  • These words can be used as identifier names, however, if double-quotes are included around the name as a delimiter every time the name is referenced.

  • When selecting from the table, use “go” (with quotes) as well.

Examples

-- This command will return an error
CREATE TABLE go
-- This command can be used. When selecting from the table, use “go" (with quotes) as well.
CREATE TABLE "go"