HetuEngine Reserved Keywords
Table 1 lists the keywords reserved by the system and whether they are reserved in other SQL standards. If you need to use these keywords as identifiers, add double quotation marks.
| 
       Keyword  | 
     
       SQL:2016  | 
     
       SQL-92  | 
    
|---|---|---|
| 
       ALTER  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       AND  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       AS  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       BETWEEN  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       BY  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       CASE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       CAST  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       CONSTRAINT  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       CREATE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       CROSS  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       CUBE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       CURRENT_DATE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       CURRENT_PATH  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       CURRENT_ROLE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       CURRENT_TIME  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       CURRENT_TIMESTAMP  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       CURRENT_USER  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       DEALLOCATE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       DELETE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       DESCRIBE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       DISTINCT  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       DROP  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       ELSE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       END  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       ESCAPE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       EXCEPT  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       EXECUTE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       EXISTS  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       EXTRACT  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       FALSE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       FOR  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       FROM  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       FULL  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       GROUP  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       GROUPING  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       HAVING  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       IN  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       INNER  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       INSERT  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       INTERSECT  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       INTO  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       IS  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       JOIN  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       LEFT  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       LIKE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       LOCALTIME  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       LOCALTIMESTAMP  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       NATURAL  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       NORMALIZE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       NOT  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       NULL  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       ON  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       OR  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       ORDER  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       OUTER  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       PREPARE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       RECURSIVE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       RIGHT  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       ROLLUP  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       SELECT  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       TABLE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       THEN  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       TRUE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       UESCAPE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       UNION  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       UNNEST  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       USING  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       VALUES  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       WHEN  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       WHERE  | 
     
       reserved  | 
     
       reserved  | 
    
| 
       WITH  | 
     
       reserved  | 
     
       reserved  | 
    
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot