4 ms·
But what's the point? You're complicating the data for no apparent gain. Only terrible RDBMSes which don't support multi-column keys require surrogate keys.
by bjourne 2y ago
But what's the point? You're complicating the data for no apparent gain. Only terrible RDBMSes which don't support multi-column keys require surrogate keys.
- konschubert 2y agoBecause you can remove or change the uniqueness constraint without having to worry about foreign key relationships.
- bjourne 2y agoEh, that's a feature of natural keys. If you try to fuck up your model your RDBMS will complain.