SQL reference for Databricks Runtime 5.5 LTS and 6.x

Important

This documentation has been retired and might not be updated. The product, service, or technology mentioned in this content is no longer supported. See SQL reference for Databricks Runtime 7.3 LTS and above.

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.