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
constraint_name='UK_CONSTRAINTNAME'
ORDER BY position;

where UK_CONSTRAINTNAME is a constraintname that you named like UK_USERSPROFILE or
UK_USERSPROFILE_FIRSTNAME.

1 comment:

Anonymous said...

Uhuhu, yes