help needed to drop unnames constraint!!!!!!!!

[abhu50]

i have created table with unnamed check constraint so pl help me to drop this check constraint also about dropping the foreign key that is unnamed???????? ???

[debasisdas]

Even though the user have not defined the name of constaints ,oracle creates all the constraints with some system defined name .

which can be found out by

[CODE=oracle]SELECT constraint_name ,constraint_typ e from user_constraint s where table_name='EMP ';[/CODE]

Then u can use the constraitns names to drop it .