Dear Professional

The following command giving me an error,

alter table make
alter column make_flag char(1) default 'Y'


"ERROR NEAR TO DEFULT KEY"

REGARDS
Noor


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 1/27/2003

Report this post to a moderator

You cannot add or remove a default constraint with the alter column
clause of the alter table statement.

You must first remove the default table contra inst bound to column
(if there is one) then add the new default constraint.

Example

alter table make
drop constraint make_Flag_Default

alter table make
add constraint make_Flag_Default default 'Y' for make_flag



On Thu, 6 Feb 2003 15:45:42 +0500, "Noorali Issani"
<noor@mail2000.com> wrote:

>Dear Professional
>
>The following command giving me an error,
>
>alter table make
>alter column make_flag char(1) default 'Y'
>
>
>"ERROR NEAR TO DEFULT KEY"
>
>REGARDS
>Noor
>
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.449 / Virus Database: 251 - Release Date: 1/27/2003
>

Report this post to a moderator