Creating the Not null column

Hi,
I changed the primary key column from Not null to null using the alter statement modify and now i wanted to change it back to the Not null. If I user the same alter statement its not taken the original key system created its own key.

Please advise me.

Thanks in advance

Admala.

can't you just drop your primary key constraint and create it again?

alter table
drop constraint ;

alter table
add constraint PK_??? PRIMARY KEY(column_name);

lesstjm ,

Thanks for ur advise but its a development table and there are lot of tables depend on this key. If I drop and recreate is it going to effect the foreign keys.

Please let me know.

Admala.