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