> ALTER TABLE OrderSummary DROP CONSTRAINT Ord_Status_Date NOT NULL > I believe I have a syntax problem, but can't figure it out.
I don't know if DROP CONSTRAINT will do it, if so, you will need to know the constraint name by looking it up in sys_constraints. To ADD a NOT NULL constraint, I simple redefine the column: ALTER TABLE OrderSummary ALTER COLUMN Ord_Status_Date DATE NOT NULL so perhaps if you do: ALTER TABLE OrderSummary ALTER COLUMN Ord_Status_Date DATE it will have the effect you want. -- Larry
