Post reply

Foregine key error

  • September 18, 2007 at 12:22 pm

    #374305

    Hi Friends

    I had Big table today i can Add One Column in that Table.

    I am getting ForegineKey Error.

    I can cheak the Relation ship of that table I can modify everything Again. It will show same Error What i can do Plz give some good Suggestions plz

    Thx

  • September 18, 2007 at 12:41 pm

    #734383

    So you can not change the Design of the table because of a ForegineKey error? How is the Foregine setup Key? And have you checked for a DB corruption? 

  • September 18, 2007 at 3:05 pm

    #734418

    If you are getting an error, it would sure help us help you to know what the error is.  Can you post the error syntax for us?  You are attempting to add a column?  How so, are you using EM or running an ALTER TABLE statement in QA?

    If foreign keys are causing you problems, drop the foreign keys, add the column, then add the foreign keys back in (WITH NOCHECK if needed).

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply