Why is that when I alter a nullable column as non nullable by creating a check
constraint ( as below ) TOAD COLUMN VIEW does not get updated.
I successfully tried to make DEPT column as non nullable using following comand.
ALTER TABLE emp1 ADD (CHECK (“DEPT” IS NOT NULL));
But TOAD COLUMN VIEW still shows that the column is nullable.Why ?