Unanswered: constraint naming schemes
Is there a preferred rationale for naming constraints?
Is there a relevant name length maximum?
I was thinking about tagging the name of the table to the end of my constraint names to make them unique -- always (I'm thinking) below 40 characters. The table name for the below eg. is bioprocessors.
FOREIGN KEY (biomasstypeID)
REFERENCES biomasstypes (biomasstypeID)
In theory, there is no difference between theory and practice. In practice there is.
Ninety-three percent of all statistics are made-up on the spot.