Alter Table
The ALTER TABLE statement changes the schema of an existing table in the catalog.
Attach/Detach
The ATTACH statement adds a new database file to the catalog that can be read from and written to.
Call
The CALL statement invokes the given table function and returns the results.
Copy
Copy Statements
Create Macro
The CREATE MACRO statement can create a scalar or table macro (function) in the catalog.
Create Schema
The CREATE SCHEMA statement creates a schema in the catalog. The default schema is main.
Create Sequence
The CREATE SEQUENCE statement creates a new sequence number generator.
Create Table
The CREATE TABLE statement creates a table in the catalog.
Create View
The CREATE VIEW statement defines a new view in the catalog.
Delete Statement
The DELETE statement removes rows from the table identified by the table-name.
Drop Statement
The DROP statement removes a catalog entry added previously with the CREATE command.
Export & Import Database
The EXPORT DATABASE command allows you to export the contents of the database to a specific directory. The IMPORT DATABASE command allows you to then read the contents again.
Insert Statement
The INSERT statement inserts new data into a table.
Statements Overview
More
Pivot Statement
The PIVOT statement allows distinct values within a column to be separated into their own columns.
Select Statement
The SELECT statement retrieves rows from the database.
Set/Reset
The SET statement modifies the provided DuckDB configuration option at the specified scope.
Unpivot Statement
The UNPIVOT statement allows multiple columns to be stacked into fewer columns.
Update Statement
The UPDATE statement modifies the values of rows in a table.
Use
The USE statement selects a database and optional schema to use as the default.
Vacuum
The VACUUM statement is primarily in place for PostgreSQL compatibility.