I've been looking at constraint properties - deferred constraints, what happens when constraints are disabled and re-enabled - and I noticed a rather confusing property of some Primary Key constraints.
Normally, when I put a primary key constraint on a column when creating a table, it will make the column NOT NULL automatically. However, some of the constraint properties seem to make this not happen!
Does anyone know the comprehensive list of when a Primary Key column might unexpectedly be able to contain NULL values?