| Alan Davis 2003-02-06, 6:23 am |
| 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
>
|