Home » SQL & PL/SQL » SQL & PL/SQL » Similiar to all_tables (Primary Keys Question)
Similiar to all_tables (Primary Keys Question) [message #222575] Mon, 05 March 2007 09:00 Go to next message
biohazardbill
Messages: 57
Registered: March 2006
Member
We have just implemented a new schema and table structure. It is not in our QA dept and they were asking me an easier way to verify. So I introduced them to all_tables and all_tab_cols. Is there a table that houses Primary Keys also to help them QA faster?

Report message to a moderator

Re: Similiar to all_tables (Primary Keys Question) [message #222583 is a reply to message #222575] Mon, 05 March 2007 09:26 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
ALL_CONSTRAINTS where CONSTRAINT_TYPE = 'P', and ALL_CONS_COLUMNS for that constraint name to list the columns in that constraint.

Report message to a moderator

Re: Similiar to all_tables (Primary Keys Question) [message #222584 is a reply to message #222575] Mon, 05 March 2007 09:31 Go to previous message
biohazardbill
Messages: 57
Registered: March 2006
Member
Thank you.

Report message to a moderator

Previous Topic: first_ value and last_value errors
Next Topic: sending a file as attachment
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 18:51:28 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.