-
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.
-
drop and recreate
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.