Altering table.

[saeed]

i want to alter a table by adding a not null constraint in one the attribute.

table name = customer

custid varchar2(10) ~Primary Key~
custname varchar2(15)
custsname varchar2(15)
custadd varchar2(40)

the table is already created but "custname" should not be left blank.
I want to know how can i alter table and add not null constraint in custname attribute.

Thanks.

Saeed.

[GJay]

ALTER TABLE customer ALTER COLUMN custname SET NOT NULL

But this will depend on what database you're using...and if there are any null entries at the moment, it won't work