Re: Invalid column name problem

Try this:

alter table dept modify (loc CHAR(30) constraint loc_nn NOT NULL);

That should work and it is the correct syntax.

HTH
STEVE Received on Mon Sep 17 2001 - 10:06:46 CDT