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.
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.
Comments