The following table lists SQL keywords that are reserved in ColdFusion queries of queries. This list includes all reserved words in the SQL standard, and should be avoided in variables used in all queries. Do not use these keywords as variable names in any queries.
| 
 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  | 
    
 CHARACTER_  | 
    
 CHAR_LENGTH  | 
  
| 
 CHECK  | 
    
 CLOSE  | 
    
 COALESCE  | 
    
 COLLATE  | 
    
 COLLATION  | 
  
| 
 COLUMN  | 
    
 COMMIT  | 
    
 CONNECT  | 
    
 CONNECTION  | 
    
 CONSTRAINT  | 
  
| 
 CONSTRAINTS  | 
    
 CONTINUE  | 
    
 CONVERT  | 
    
 CORRESPONDING  | 
    
 COUNT  | 
  
| 
 CREATE  | 
    
 CROSS  | 
    
 CURRENT  | 
    
 CURRENT_DATE  | 
    
 CURRENT_TIME  | 
  
| 
 CURRENT_  | 
    
 CURRENT_  | 
    
 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  | 
    
 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_  | 
    
 TIMEZONE_  | 
    
 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  | 
    
 
  | 
    
 
  | 
    
 
  |