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

Note

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

• For the Databricks SQL language reference, see SQL language 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.

• Alter Database
• Alter Table or View
• Alter Table Partition
• Analyze Table
• Cache Select (Delta Lake on Databricks)
• Cache Table
• Clear Cache
• Clone (Delta Lake on Databricks)
• Convert To Delta (Delta Lake on Databricks)
• Copy Into (Delta Lake on Databricks)
• Create Bloom Filter Index (Delta Lake on Databricks)
• Create Database
• Create Function
• Create Table
• Create View
• Delete From (Delta Lake on Databricks)
• Deny
• Describe Database
• Describe Function
• Describe Table
• Describe History (Delta Lake on Databricks)
• Drop Bloom Filter Index (Delta Lake on Databricks)
• Drop Database
• Drop Function
• Drop Table
• Drop View
• Explain
• Fsck Repair Table (Delta Lake on Databricks)
• Functions
• Generate (Delta Lake on Databricks)
• Grant
• Insert
• Load Data
• Merge Into (Delta Lake on Databricks)
• Msck
• Optimize (Delta Lake on Databricks)
• Refresh Table
• Reset
• Revoke
• Select
• Set
• Show Columns
• Show Create Table
• Show Databases
• Show Functions
• Show Grants
• Show Partitions
• Show Table Properties
• Show Tables
• Truncate Table
• Uncache Table
• Update (Delta Lake on Databricks)
• Use Database
• Vacuum