FedSQL Reserved Words

The following words are reserved as FedSQL language keywords and cannot be used as variable names or in any other way.

Note: You can use delimited identifiers for terms that might otherwise be a reserved word. For example, to use the term “char” other than for a character declaration, you would use it as the delimited identifier “char”. For more information, see Delimited Identifiers.

FedSQL Reserved Words A - D
`A` ABORT ABSOLUTE ACCESS ACTION ADD AFTER AGGREGATE ALL ALLOCATE ALTER ANALYSE ANALYZE AND ANY ARE ARRAY AS ASC ASENSITIVE ASSERTION ASSIGNMENT ASYMMETRIC AT ATOMIC AUTORIZATION `B` BACKWARD BEFORE BEGIN BETWEEN BIGINT	BINARY BIT BLOB BOOLEAN BOTH BY `C` CACHE CALL CALLED CARDINALITY CASCADE CASCADED CASE CAST CHAIN CHAR CHAR_LENGTH CHARACTER CHARACTER_LENGTH CHARACTERISTICS CHECK CHECKPOINT CLASS CLOB CLOSE CLUSTER COALESCE COLLATE COLLECT COLUMN	COMMENT COMMIT COMMITTED CONDITION CONNECT CONSTRAINT CONSTRAINTS CONVERSION CONVERT COPY CORR CORRESPONDING COVAR_POP COVAR_SAMP CREATE CREATEDB CREATEUSER CROSS CUBE CUME_DIST CURRENT CURRENT_DATE CURRENT_DEFAULT_TRANSFORM_GROUP CURRENT_PATH CURRENT_ROLE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_TRANSFORM_GROUP_FOR_TYPE CURRENT_USER CURSOR CYCLE	`D` DATABASE DAY DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFAULTS DEFERRABLE DEFERRED DEFINER DELETE DELIMITER DELIMITERS DENSE_RANK DEREF DESC DESCRIBE DETERMINISTIC DISCONNECT DISTINCT DO DOMAIN DOUBLE DROP DYNAMIC

FedSQL Reserved Words E - O
`E` EACH ELEMENT ELSE ENCODING ENCRYPTED END END-EXEC ESCAPE EVERY EXCEPT EXCLUDING EXCLUSIVE EXEC EXECUTE EXISTS EXPLAIN EXTERNAL EXTRACT `F` FALSE FETCH FILTER FIRST FLOAT FOR FORCE FOREIGN FORWARD FREE FREEZE FROM FULL FUNCTION FUSION	`G` GET GLOBAL GRANT GROUP GROUPING `H` HANDLER HAVING HOLD `I` ILIKE IMMEDIATE IMMUTABLE IMPLICIT IN INCLUDING INCREMENT INDEX INDICATOR INHERITS INITIALLY INNER INOUT INPUT INSENSITIVE INSERT INSTEAD INT INTEGER INTERSECT INTERSECTION INTERVAL INTO INVOKER IS ISNULL ISOLATION	`J` JOIN `K` KEY `L` LANCOMPILER LANGUAGE LARGE LAST LATERAL LEADING LEFT LEVEL LIKE LIMIT LISTEN LOAD LOCAL LOCALTIME LOCALTIMESTAMP LOCATION LOCK `M` MATCH MAXVALUE MEMBER MERGE METHOD MINUTE MINVALUE MODE MODIFIES MODULE MONTH MOVE MULTISET	`N` NAMES NATIONAL NATURAL NCHAR NCLOB NEW NEXT NO NOCREATEDB NOCREATEUSER NONE NORMALIZE NOT NOTHING NOTIFY NOTNULL NULL NULLIF NUMERIC `O` OF OFF OFFSET OIDS OLD ON ONLY OPEN OPERATOR OPTION OR ORDER OUT OUTER OVER OVERLAPS OVERLAY OWNER

FedSQL Reserved Words P - Z
`P` PARAMETER PARTIAL PARTITION PASSWORD PATH PENDANT PERCENT_RANK PERCENTILE_CONT PERCENTILE_DESC PLACING POSITION PRECISION PREPARE PRESERVE PRIMARY PRIOR PRIVILEGES PROCEDURAL PROCEDURE `R` RANK READ READS REAL RECHECK RECURSIVE REF REFERENCES REFERENCING REGR_AVGX REGR_AVGY REGR_COUNT REGR_INTERCEPT REGR_R2 REGR_SLOPE REGR_SXX REGR_SXY REGR_SYY REINDEX RELATIVE RENAME	REPLACE RESET RESTART RESTRICT RESULT RETURN RETURNS REVOKE RIGHT ROLLBACK ROLLUP ROW ROWS ROW_NUMBER RULE `S` SCHEMA SCOPE SCROLL SEARCH SECOND SECURITY SELECT SENSITIVE SPECIFIC SPECIFICTYPE SEQUENCE SERIALIZABLE SESSION SESSION_USER SET SETOF SHARE SHOW SIMILAR SIMPLE SMALLINT SOME SQLEXCEPTION SQLSTATE SQLWARNING STABLE START	STATEMENT STATIC STATISTICS STDDEV_POP STDDEV_SAMP STDIN STDOUT STORAGE STRICT SUBMULTISET SUBSTRING SYMMETRIC SYSID SYSTEM SYSTEM_USER `T` TABLE TABLESAMPLE TEMP TEMPLATE TEMPORARY THEN TIME TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE TO TOAST TRAILING TRANSACTION TRANSLATE TRANSLATION TREAT TRIGGER TRIM TRUE TRUNCATE TRUSTED TYPE `U` UESCAPE UNENCRYPTED	UNION UNIQUE UNKNOWN UNLISTEN UNNEST UNTIL UPDATE USAGE USER USING `V` VACUUM VALID VALIDATOR VALUE VALUES VARCHAR VARYING VAR_POP VAR_SAMP VERBOSE VERSION VIEW VOLATILE `W` WHEN WHENEVER WHERE WIDTH_BUCKET WINDOW WITH WITHIN WITHOUT WORK WRITE `Y` YEAR `Z` ZONE

Last updated: February 23, 2017