Databricks Runtime 5.5 LTS 和 6.x SQL 参考Databricks Runtime 5.5 LTS and 6.x SQL reference

下面是 Databricks Runtime 5.5 LTS 和 6.x 中支持的数据定义语言 (DDL) 和数据操作语言 (DML) 构造的完整列表。This is a complete list of Data Definition Language (DDL) and Data Manipulation Language (DML) constructs supported in Databricks Runtime 5.5 LTS and 6.x. 有关 Databricks Runtime 7.x SQL 命令,请查看 Databricks Runtime 7.x SQL 参考For Databricks Runtime 7.x SQL commands, see Databricks Runtime 7.x SQL reference.


如果要编写 SQL 查询,无论是在 SQL 笔记本中编写还是使用不同的默认语言在笔记本的 %sql magic 命令中编写,均不能在标识符中使用 $,因为它会被解释为参数。If you write a SQL query, either in a SQL notebook or in %sql magic command in a notebook with a different default language, you cannot use $ in an identifier because it is interpreted as a parameter. 若要在 SQL 命令单元中转义 $,请使用 $\To escape a $ in SQL command cells, use $\. 例如,若要定义标识符 $foo,请将其编写为 $\fooFor example, to define the identifier $foo, write it as $\foo.