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.

Comments

Anonymous said…
Uhuhu, yes

Popular posts from this blog

LVM: How to remove a volume using pvremove

Use Shell Editor for Eclipse for editing bash, ksh, csh in Unix/Linux system

pdftotext not found in CentOS