4 ms·
I wonder if a generated column can be referenced as a foreign key. Weirdness wouod probably ensue, so I'd guess... No?
by yourad_io 7y ago
I wonder if a generated column can be referenced as a foreign key. Weirdness wouod probably ensue, so I'd guess... No?
- mslot 7y agoYes. A generated column can be included in a foreign key and be referenced by a foreign key. Nothing too weird happens. It's basically like having every update and insert specify the column value.