SELECT *
FROM USER_CONSTRAINTS
WHERE table_name ='tua_tabella';