Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What's the point in create relation
Message
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Titre:
What's the point in create relation
Divers
Thread ID:
01683727
Message ID:
01683727
Vues:
36
I see this very often, and I am wondering what's the point in creating foreign key constraints in the database without actions?

In VFP tables we were used to enforce foreign key relations purely in the business logic and how the queries are built. In SQL Server, if you create fk constraints, they show the relations in the diagram. But other than that, is there a purpose for it? Unless you specify any cascading actions (which I would not like to do) does it have any advantage?
Christian Isberner
Software Consultant
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform