Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's the point in create relation
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
01683727
Message ID:
01683728
Views:
39
>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?

You can't create lost childs.

MartinaJ
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform