> Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > > I have throught of at least two problems with changing nullability. The > > first is primary keys. I have to prevent people setting a > column involved > > in a PK to null, right? > > Probably so.
What about temporary tables - is there any reason they shouldn't be able to modify a temporary table? What about indices? Will twiddling the nullability break indices on a table in any way? And foreign keys - foreign keys only have to reference UNIQUE, right? The nullability isn't an issue? Lastly - in a multicolumn primary key, does EVERY column in the key need to be NOT NULL? Chris ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
