Not able to drop default constraint of a table column

Help Procedural SQL
1

“ALTER TABLE tablename ALTER COLUMN columnname datatype DROP DEFAULT” is not working on a singlestore table.

I just want to drop the default constraint on the table column

I cannot use the work around of dropping a colum and then again adding the same column as do not want to loose the data in that column.

2

Sorry to hear that. Try creating a new column (without the DEFAULT), then updating it with the data from the original column. Then drop the old column. Then rename the new column to use the same name as the old one.