Monday, 8 September 2014

BP deviation - Only foreign key constraints are allowed on this table

BP deviation - Only foreign key constraints are allowed on this table.

Often times, we end up getting this BP violation message when we run the BP check on the tables.
Here is the resolution,

  • Check if you have created new relation for the table
  • If yes, check how the relation was created - relation got created automatically by the system just by adding a new field, or was it created manually.
  • This BP message comes when you create relation manually especially if you have created Normal relation
  • Avoid creating the normal relation, use ForeignKey relation instead.
  • Delete the one which is already created thru Normal relation and create newly thru ForeignKey relation.


This should fix the above BP violation.

No comments:

Post a Comment