SQL Reserved Words – The Empirical List

The author presents a chart that lists words that are rejected as non-delimited table or column names by various SQL systems. The chart includes systems such as Apache Derby, BigQuery, Db2 (LUW), H2, MariaDB, MySQL, Oracle DB, PostgreSQL, SQL Server, and SQLite. The author notes that some words that are actually reserved words in SQL can still be used as identifiers by putting them under double quotes. It is interesting to see which systems accept certain words as unquoted table or column names. The author also suggests subscribing to their newsletter to keep up with SQL evolution. The author’s name is Markus Winand, and they offer training, speaking, and consulting services.

https://modern-sql.com/reserved-words-empirical-list

To top