If you want to change the values of all records use this

UPDATE MYTABLE SET MYCOLUMN = 'some value'

Paul

----- Original Message -----
From: "Dmitry Yemanov" <dimitr@...>
To: <IBDI@yahoogroups.com>
Sent: Friday, February 23, 2001 6:14 AM
Subject: [IBDI] DEFAULT Values


> Hi,
>
> As far as I understand, I cannot change DEFAULT value of the existing
> column. 'ALTER TABLE table_name ALTER COLUMN column_name' statement does
not
> allow SET DEFAULT syntax, although it is defined by the SQL 92
> specification. 'ALTER DOMAIN domain_name SET DEFAULT' statement changes
> default value for the given domain, but does not affect the existing
columns
> based on this domain.
>
> If I'm wrong, please point me what I'm missing. Otherwise, maybe we need
> something to add/change there. Any thoughts?
>
> Cheers,
> Dmitry
>
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>