Obedience Training For Databases: Cascading Constraints

Question

Obedience Training For Databases: Cascading Constraints

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

cbowman Valued Member Points: 72 More actions · Answer 1

Am I missing something ( probably am), but I don't see how or why this is better than using a surrogate key and join clause. If it needs to be simple for queries, write a view.

Charles Kincaid SSChampion Points: 13593 More actions · Answer 2

The point of the tiny fact table and foreign key is that to add new items is an INSERT. To change the check constraint you must drop the old check constraint and add the revised version back.

ATBCharles Kincaid

John Corkett SSCrazy Points: 2279 More actions · Answer 3

Neither do you need a join. In a view you would still be using a join.

Thanks,

John