Alter table quey

Gayatri_Lakule · December 1, 2025, 12:37pm

Hello,

I want to update an existing table sampletable by setting the default value of the auditdate column to CURRENT_TIMESTAMP.
However, the following query is not working:

ALTER TABLE sampletable
ALTER COLUMN auditdate TIMESTAMP WITH TIME ZONE
SET DEFAULT CURRENT_TIMESTAMP;

Please help in this senario.

surister · December 1, 2025, 12:44pm

Hi, It is currently not supported by CrateDB, this is the ticket tracking this feature request, you could thumbs up to signal interest to the core team.

github.com/crate/crate

Support `ALTER TABLE x ALTER COLUMN y SET DEFAULT`

opened 10:36AM - 01 Dec 25 UTC

hammerhead

contributions welcome feature: sql: ddl complexity: no estimate

### Problem Statement Users occasionally want to change a columns' default valu…e. Either to retrospectively add a new default value to an existing column that didn't have a default value before, or to change the default value from one value to another. ### Possible Solutions PostgreSQL supports [changing a column's default value](https://www.postgresql.org/docs/current/ddl-alter.html#DDL-ALTER-COLUMN-DEFAULT) with a statement such as: ```sql ALTER TABLE products ALTER COLUMN price SET DEFAULT 7.77; ``` It does not have an effect on existing data: > Note that this doesn't affect any existing rows in the table, it just changes the default for future INSERT commands. ### Considered Alternatives Add a new column with the updated default value, copy data over, and switch columns.

Topic		Replies	Views
Add default value to column Community	1	8	December 1, 2025
Created_at not populated with default value during insert in CrateDB via C# SQL sql	1	33	August 14, 2025
Alter table and add new column if already exists CrateDB sql	1	132	April 3, 2024
Alter a table created on an older version SQL	1	853	August 14, 2019
Schema evolution via Confluent JDBC sink is failing due to wrong ALTER request CrateDB	3	2854	May 12, 2021

Alter table quey

Related topics