var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to add a not null constraint to an existing column
Vesrion 8.1 FP5
OS : Solaris 2.8
Can we add a not null constratint to an existing column?
If not what is the solution for this?
You have to drop the table and recreate it.
The other option you have is to add a check constraint by ALTERing the table ...
ALTER TABLE TABLE1 ADD CONSTRAINT constraint1 check (col1 is not null)
But, I do not have a definitive idea on the performance difference between a not null check constraint and a base table column definition ...
Visit the new-look IDUG Website
, register to gain access to the excellent content.