View Single Post

   
  #2 (permalink)  
Old 04-08-2008, 06:15 PM
species8472
 
Posts: n/a
Default Re: how to disable constraint

tony73 wrote:
> ASE 12.5
>
> Dear everybody,
>
> I should delete some rows in a table but i have several constraint on
> some fields on that table,
> and i 'm not able to do it.
>
> does somebody know how it is possible to disable the constraint on one
> table please ?
>
> I tried
>
> ALTER table DISABLE contraint did not work
>
>
> some other ideas please ?
>
> Antonio
>

That's relational databases for you :-)


You can't disable a constraint, only drop and recreate.
But what you should do is delete from the child table upwords.

Reply With Quote