Hello. Your command is definitely not valid. Where did you find it? We don't have such syntax in the documentation. It was accepted due to bug.
Use ALTER TABLE tableName ALTER COLUMN columnName SET NOT NULL instead. The SET DATA TYPE clause may be used only to change the data type of the column, it is officially supported since 1.4.198. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/9a983220-552e-417e-a1ed-0feec726f87a%40googlegroups.com.