[firebird-support] alter column drop default (firebird 2.x)

[Maximiliano Robaina]

Hi,

If I want to drop a column-level default, in firebird 2.x I can do 

ALTER TABLE tablename ALTER [COLUMN] colname DROP DEFAULT

But, if [COLUMN] has not a default value setting, that statement raise
an error.
The question is, How can I to know if a field has set a default value?

Query against system tables? Which one?


Thanks in advance
Maxi.