What SYS.USER_ view shows the primary keys for a table?

0 ⤊

What SYS.USER_ view shows the primary keys for a table?

SYS.USER_TABLES shows the tables in the database, SYS.USER_COLUMNS shows the columns in the table, how do I find out which columns are primary keys?

2007-03-14 08:22:32 · 2 answers · asked by hello 6 in Computers & Internet ➔ Programming & Design

I am using Toad software to view the database.

2007-03-14 08:22:54 · update #1

2 answers

Well, if you're using TOAD, just use the schema browser to look at the table and select the constraint tab.

Otherwise, have a look at user_constraints

2007-03-15 19:53:31 · answer #1 · answered by BigRez 6 · 0⤊ 0⤋

challenging factor. do a search into google and yahoo. just that can assist!

2014-12-10 19:35:39 · answer #2 · answered by Anonymous · 0⤊ 0⤋