SEO

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

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.

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
>