SQL reference for Databricks Runtime 5.5 LTS and 6.x

Important

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 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.

Note

  • For Databricks Runtime 7.x and above SQL commands, see SQL reference.

  • For the Databricks SQL language reference, see SQL reference.

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.