sql_keywords function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 13.3 LTS and above

Returns the set of SQL keywords in Databricks.

Syntax

sql_keywords()

Arguments

This function takes no arguments.

Returns

A set of rows composed of two columns:

  • keyword STRING NOT NULL: The name of the SQL keyword

  • reserved BOOLEAN NOT NULL: true if the keyword is reserved.

Keywords in Databricks are only reserved under certain conditions. See ANSI compliance in Databricks Runtime for more details.

Examples

> SELECT keyword, reserved FROM sql_keywords() ORDER BY keyword LIMIT 2;
 ACTION false
 ADD    false