Appendix A

SQL Keywords

The SQL standard defines a set of reserved keywords and nonreserved keywords that are used within your SQL statements. You cannot use reserved keywords as identifiers. In addition, it is generally a good idea to avoid using nonreserved keywords. Note that the SQL standard warns that it makes no guarantees about what keywords might be added to the standard in the future. As a result, an identifier you use in a current database might not be usable in future releases of SQL. You can avoid conflicts with future reserved keywords by adding a digit or an underscore to your identifiers, especially those composed of only a single word, and by not beginning an identifier with current_, session_, system_, or timezone_, or ending ...

Get SQL: A Beginner's Guide, Fourth Edition, 4th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.