SQL reference
This is a complete list of Data Definition Language (DDL) and Data Manipulation Language (DML) constructs supported in Databricks for Apache Spark SQL and Delta Lake.
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 Partitions
- Analyze Table
- Cache
- Cache Table
- Clear Cache
- Convert To Delta (Delta Lake on Databricks)
- Copy Into (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 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 Grant
- Show Partitions
- Show Table Properties
- Show Tables
- Truncate Table
- Uncache Table
- Update (Delta Lake on Databricks)
- Use Database
- Vacuum