>Hi Guys,
>
>Is it possible to add a default value to an existing column in a SQL Table?
>I've tried this but it does'nt work
>
>ALTER TABLE Customer
>ALTER COLUMN flag SET DEFAULT 1
>
>Any idea?
>
>
>Thanks in advance...
ALTER TABLE Customer ALTER COLUMN Flag DEFAULT 1
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.