SQL reference for Databricks Runtime 5.5 LTS and 6.x

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.

Note

Note

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. To escape a $ in SQL command cells, use $\. For example, to define the identifier $foo, write it as $\foo.