SQL reference for Databricks Runtime 5.5 LTS and 6.x


This documentation has been retired and might not be updated. The products, services, or technologies mentioned in this content are no longer supported. See SQL language reference.

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.



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.