Primary key columns dropped with cascade constraint
RamanMay 24 2007 — edited May 24 2007Hi,
My developer dropped one column from table which was having primary key . (primary key on two columns now one column is there)
he used SQL > alter table table_name drop columns cascade constraints.
Now i want to enable the constraint. the constraint is not there. if i am creating the primary key with the existing single column alone.
My question how do i know which was the dependency it had? (like foreign key / child tables it had?) and how to rebuild the relationship?
Thanks
--Raman