Re: How many of you use foreign key constraints and References in your database schema?

On 2017-11-01 15:21, Bill Anderson wrote:

Mike,

...

...

Where's your preference in design with these in mind?<<

My philosophy is that the back end database, whatever it is, should be a dumb as a rock. A database should only be concerned with its internal integrity and no more. Anything else is pretty much geared toward vendor lock-in.

But having noted that, FK constraints are absolutely a part of the data integrity. So yes, use 'em.

Views? Sure, that's basically the only way to communicate. Business rules? Nope, stay away. That's for middleware.

Bill Anderson

Hi Bill!

I agree completely.

--Mike