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