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

Question

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.

Can you try `Alter table blablub alter column test set default '0'`? — thiyaga, Jan 02 '14 at 11:53

Grzegorz Oledzki · Accepted Answer · 2014-01-02T13:19:46.263

2

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

edited Jan 02 '14 at 13:19

answered Jan 02 '14 at 11:55

Grzegorz Oledzki

if you remove the '0' then that's the solution. I updated my post thanks to you. – deW1 Jan 02 '14 at 12:10
OK. Removed that '0'. – Grzegorz Oledzki Jan 02 '14 at 13:19

1 Answers1