Thursday, September 11, 2008

find table contstraint in oracle database

free toad does not provide a constraint view.

select * from user_constraints where constraint_name = 'THE_CONSTRAINT_NAME';

TABLE_NAME is the name of the table that has the constraint, and probably is the table you need to delete stuff from to clear the constraint

No comments:

Post a Comment