My previous mail correction.

Set default and drop default clause added for alter table statement in
firebird 2,0



Alter table tt alter field1 set default default_value

Alter table tt alter field1 drop default





_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of ibrahim bulut
Sent: Saturday, August 18, 2007 9:15 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] change default value



Firebird 2,0 can do it. alter default and drop default statements for this.

Have a look release notes

_____

From: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com
[mailto:firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com] On Behalf Of Dmitry Yemanov
Sent: Saturday, August 18, 2007 8:15 AM
To: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com
Subject: Re: [firebird-support] change default value

Martijn Tonies wrote:

>
> There's no ALTER TABLE to do that

Really? :-)

Dmitry

__________ NOD32 2469 (20070818) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset <http://www.eset.com> com

[Non-text portions of this message have been removed]



__________ NOD32 2469 (20070818) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com



[Non-text portions of this message have been removed]