Constraints

Is it considered redundant to have a primary key, unique constraint and a not null constraint all on the same column or is it considered a good practice to define all three even though the primary key constraint effectively enforces both not-null and unique constraints? Received on Mon Jul 10 2000 - 00:00:00 CDT