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 constraint_name='UK_CONSTRAINTNAME' ORDER BY position; where UK_CONSTRAINTNAME is a constraintname that you named like UK_USERSPROFILE or UK_USERSPROFILE_FIRSTNAME.