views:

36

answers:

1

So for a weird reaon my table was dropped but the constraints remained so I cannot recreate the table with the same constraints.. Is there a way I can drop those constraints?

When I do a select in the all_constraints table:

select * from all_constraints where CONSTRAINT_NAME like 'C710%';

I get this: ("x" being the table_name which means the table doesnt exist?)

C710_C700_INT_MESSAGE_ID_FK R x

C710_INT_PROFILE_PK P x

C710_UPDATED_TS_CK C x

I tried PURGE RECYCLEBIN; with no success

A: 

Ok nevermind, SQL Developer didnt actually drop the table, it created another one named "x"..

programmeuuuuh514