Subject Re: [firebird-support] adding default syntax
Author Hans
Thank You.

Used the wrong 2.5.0 docs :)

Is there a place with all the docs in one place ?


----- Original Message -----
From: "Thomas Steinmaurer" <ts@...>
To: <firebird-support@yahoogroups.com>
Sent: Saturday, October 23, 2010 3:16 PM
Subject: Re: [firebird-support] adding default syntax


> Hello Hans,
>
>> After having created a Relation Column, was is the syntax to alter that
>> Column to Default 0 ?
>>
>> For example.
>>
>> Alter Table Test add Saldo integer.
>>
>> then
>>
>> Alter Table Alter Saldo to Saldo type Integer Default 0, but that doesn't
>> work
>
> Firebird 2.1.3 release notes p. 39:
>
> ALTER TABLE t ALTER [COLUMN] c SET DEFAULT default_value;
> ALTER TABLE t ALTER [COLUMN] c DROP DEFAULT;
>
>
>
> --
> Best Regards,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database, MS SQL Server and
> NexusDB V2
> Upscene Productions
> http://www.upscene.com
> My blog:
> http://blog.upscene.com/thomas/
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>