Re: how to disable constraint Aren't you addressing the wrong problem? It appears as if some columns on
the rows that you want to delete act as a primary key for other tables. If
so, you should first be deleting rows on those "child" tables.
If I misunderstand perhaps you can clarify the problem with more detail.
"tony73" <tony73@email.it> wrote in message
news:1138182662.125838.232490@z14g2000cwz.googlegr oups.com...
>
> 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
> |