Drop system generated constraint
Hi All,
In a table I am having primary key called abc_pk for column. Mistakenly i have given the same name for foreign key as abc_pk and executed. As of me if same name for constraint then oracle will generate own constraint name such as sys_co4537.. if it is wrong correct me...
if oracle itself generated constraint name then how to find constraint correct constraint name....
case 1: if it single database i can find it in corresponding table with reference key..as (sys_co4537)
case 2: If i am having more than 2 database then it difficult to find because each database will create different name...
pls suggest me how to drop sys_* constraint from different database..
Thanks & Regards
Sami