Resources

ALTER TABLE Statement

duckdb.org

The ALTER TABLE statement changes the schema of an existing table in the catalog. Examples Add a new column with name k to the table integers, it will be filled with the default value NULL: ALTER TABLE integers ADD COLUMN k INTEGER; Add a new column with name l to the table integers, it will be filled with the default value 10: ALTER TABLE integers ADD COLUMN l INTEGER DEFAULT 10; Drop the column k from the table in…

Visit Site