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?
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.
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.
Previous Topic: first_ value and last_value errors
Next Topic: sending a file as attachment
Goto Forum:
  


Current Time: Thu Dec 08 02:04:47 CST 2016

Total time taken to generate the page: 0.10072 seconds