title: Drop Unique Constraint on Table Column without Knowing the Constraint Name
body: <p>In Oracle 10g, how can I drop a unique constraint on a column without knowing the name of the constraint (e.g. a system generated name, which won't necessarily be the same across database instances)? Dropping and recreating the table isn't an option. Is it possible?</p>