Subject | alter column drop default (firebird 2.x) |
---|---|
Author | Maximiliano Robaina |
Post date | 2012-01-17T12:50:32Z |
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.
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.