creation date

[Ruslan Zasukhin]

On 3/4/07 1:25 PM, "Kim Kohen" <kim at webguide.com.au> wrote:

Hi Kim,

>> 1) SQL:  ALTER TABLE
> €€€€
> what's the correct syntax for this, the docs aren't clear:
> 
> ALTER TABLE age SET DEFAULT Œ25¹  Is age a table or field??
> Whichever it is, how is the other determined?
> 
> shouldn't it be something like:
> 
> alter table mytable column myfield set default 'false'
> 
> I've tried everything without luck.  I also tried:
> 
> alter table mytable alter column myfield set default 'false' and it
> crashed VStudio.

Here

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documen
tation:vsql:reference:altertable

Is said:

alter_table_action
   |    MODIFY [ COLUMN ] column_definition



So:

    ALTER TABLE mytable MODIFY COLUMN myfield DEFAULT 'false'


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]