Search code examples
sqlsqlbase

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

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.

Solution

  • 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