| how to get the key of a relation? [message #2131] |
Sun, 23 June 2002 21:04  |
keane
Messages: 23
Registered: June 2002
|
Junior Member |
|
|
hi, I have a problem with getting the key of a relation by not looking at the relation creation schema. Can I do it through data dictionary? Thanks a lot!
keane
|
|
|
|
| Re: how to get the key of a relation? [message #2145 is a reply to message #2131] |
Mon, 24 June 2002 08:58  |
Siva Ram
Messages: 22
Registered: November 2001
|
Junior Member |
|
|
Hi Keane
From what you have wrote, I could understand as : U want to know the constraint on a table(s), if so :
SQL> Select Constraint_name, Constraint_type from user_constraints where table_name='
';
replace TABLENAME with the table you want, but type the tablename in UPPERCASE.
Thank You
Siva Ram
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
