Does SQL Base have an option to set a DEFAULT Value to a column? Like
ALTER TABLE blablub MODIFY test SET DEFAULT '0'
Solution, thanks to Grzegorz Oledzki:
ALTER TABLE blablub MODIFY test NOT NULL WITH DEFAULT
However kinda stupid since you can't define the DEFAULT value yourself.
This is the first time I hear of SQLBase, but after googling I found the documentation which at page 3-11 suggests something like:
ALTER TABLE blablub MODIFY test <DATATYPE> NOT NULL WITH DEFAULT