Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's the point in create relation
Message
From
03/03/2022 02:06:39
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
What's the point in create relation
Miscellaneous
Thread ID:
01683727
Message ID:
01683727
Views:
35
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
Next
Reply
Map
View

Click here to load this message in the networking platform