Tuesday, July 20, 2010

Oracle DB - Get the constraints information from a table

I'm beginning now to use Oracle fro development, now expect that I'll be having more

SELECT table_name, column_name, CONSTRAINT_NAME
FROM all_cons_columns
WHERE owner='username_owner' AND
ORDER BY position;

where UK_CONSTRAINTNAME is a constraintname that you named like UK_USERSPROFILE or