Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: View to check RI contrainsts infomration on tables?

Re: View to check RI contrainsts infomration on tables?

From: <G.Plivna_at_itsystems.lv>
Date: Sun, 25 Aug 2002 06:38:18 -0800
Message-ID: <F001.004BF3C0.20020825063818@fatcity.com>

user/all/dba_constraints should be enough

Gints Plivna
IT Sistēmas, Merķeļa 13, LV1050 Rīga
http://www.itsystems.lv/gints/

                                                                                                                                        
                      Abdul Aleem                                                                                                       
                      <dmit_at_beaconhouse        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                    
                      .edu.pk>                 cc:                                                                                      
                      Sent by:                 Subject:  View to check RI contrainsts infomration on tables?                            
                      root_at_fatcity.com                                                                                                  
                                                                                                                                        
                                                                                                                                        
                      2002.08.24 11:28                                                                                                  
                      Please respond to                                                                                                 
                      ORACLE-L                                                                                                          
                                                                                                                                        
                                                                                                                                        




Hi,

Which view(s) should I look into to build complete foreign key / primary key, or any other constraint on a table.

TIA! Aleem

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Abdul Aleem
  INET: dmit_at_beaconhouse.edu.pk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: G.Plivna_at_itsystems.lv Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sun Aug 25 2002 - 09:38:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US