View Single Post

   
  #3 (permalink)  
Old 04-08-2008, 04:04 PM
Ulrike Zintz
 
Posts: n/a
Default Re: How can I avoid Dependent foreign key constraint

Hi Manuel,

I think I misunderstood your message.

If you update/delete the primary key on a table and you would like to
do the same with the foreign keys, you could use a trigger.

Regards,
Ulrike


"Manuel Blechschmidt" <Manuel.Blechschmidt@gmx.de> wrote in message news:<bogs5i$k2b$05$1@news.t-online.com>...
> Hello,
> I am really new to Sybase I have the following problem:
> Dependent foreign key constraint violation in a referential integrity
> constraint. dbname = 'naturideen', table name = 'products', constraint name
> = 'fk_sub_products_ref_sub'. (number=547 severity=16 state=1)
> Could somebody explain me how to solve it or show me the soloution in the
> manual?
> Greetings
> Manuel

Reply With Quote