I have a business requirement to have a FK field on
TableB. If there is a value in
TableBID, it should be unique, but it's not mandatory, so there could be multiple records with null values.
Is it possible somehow to enforce this type of uniqueness on the DB level, using either an index or a constraint?