The existing relationship must have at least one pair of related columns.
There must be matching columns on both sides of a foreign key relationship. Deleting a column that is part of a relationship will disable the relationship.
Creating and Managing Database Diagrams | Working with Database Objects |
Database Diagrams |