保留关键字
下面表格罗列了AIR中所有预定的关键字及其在SQL标准中的状态。这些保留关键字若用作标识符,必须采用双引号进行引用。
| Keyword (AIR) | 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 |
| CATALOG | ||
| CONSTRAINT | reserved | reserved |
| CREATE | reserved | reserved |
| CROSS | reserved | reserved |
| CUBE | reserved | |
| CURRENT_DATE | reserved | reserved |
| CURRENT_TIME | reserved | reserved |
| CURRENT_TIMESTAMP | reserved | reserved |
| CURRENT_USER | reserved | |
| CLUSTER | ||
| DEALLOCATE | reserved | reserved |
| DEFAULT | ||
| 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 | |
| HAVING | reserved | reserved |
| IN | reserved | reserved |
| INNER | reserved | reserved |
| INSERT | reserved | reserved |
| INTERNAL | ||
| INTERSCHEMA | ||
| INTERSECT | reserved | reserved |
| INTO | reserved | reserved |
| IS | reserved | reserved |
| JOIN | reserved | reserved |
| LEFT | reserved | reserved |
| LIKE | reserved | reserved |
| LOCALTIME | reserved | |
| LOCALTIMESTAMP | reserved | |
| METERIALIZATION | ||
| NATURAL | reserved | reserved |
| NORMALIZE | reserved | |
| NOT | reserved | reserved |
| NULL | reserved | reserved |
| ON | reserved | reserved |
| OR | reserved | reserved |
| ORDER | reserved | reserved |
| OUTER | reserved | reserved |
| PREPARE | reserved | reserved |
| PROJECTION | ||
| RECURSIVE | reserved | |
| REFRESH | ||
| RIGHT | reserved | reserved |
| ROLLUP | reserved | |
| SELECT | reserved | reserved |
| SHOW | ||
| TABLE | reserved | reserved |
| THEN | reserved | reserved |
| TRUE | reserved | reserved |
| UESCAPE | reserved | |
| UNION | reserved | reserved |
| UNNEST | reserved | |
| USING | reserved | reserved |
| VALUES | reserved | reserved |
| VARIABLES | ||
| WHEN | reserved | reserved |
| WHERE | reserved | reserved |
| WITH | reserved | reserved |