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
03-29-2001, 04:14 PM
drop and recreate
can't you just drop your primary key constraint and create it again?
drop constraint ;
add constraint PK_??? PRIMARY KEY(column_name);
03-29-2001, 04:22 PM
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.