How to Add a Column in DuckDB

This example adds the column my_new_column of type TEXT to the existing table my_table:

ALTER TABLE my_table
ADD COLUMN my_new_column TEXT;

Get started with DB Pilot

DB Pilot is a Database GUI client and SQL editor for PostgreSQL, MySQL, SQLite, DuckDB & more.