How to add a not null constraint to an existing column

prithvi_raj · #1 (**permalink**) 06-07-04, 10:18

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?

dsusendran · #2 (**permalink**) 06-07-04, 10:22

You have to drop the table and recreate it.

Newbie

sathyaram_s · #3 (**permalink**) 06-07-04, 11:46

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 ...

Cheers
Sathyaram

Internet Services

Web Development

Digital Marketing

Consumer Tech