Is it possible to set a default value to a column in SQLBase?

220 views Asked by At

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:

From Docu

ALTER TABLE blablub MODIFY test NOT NULL WITH DEFAULT

However kinda stupid since you can't define the DEFAULT value yourself.

1

There are 1 answers

2
Grzegorz Oledzki On BEST ANSWER

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