select * from ALL_CONSTRAINTS where constraint_name = 'YoConstraint'

Had one that wouldn't drop when the table was dropped (with CASCADE CONSTRAINTS;), and had to go search to see where the constraint with the same name as the one I was re-building lived. Voila.

(No, my constraint in production was not called 'YoConstrait'. That's yo' constraint name, not mine, okay?)

Labels: ,