constraint type

From: David So <davids_at_Software.Mitel.COM>
Date: 12 Feb 93 21:32:50 GMT
Message-ID: <14010_at_davids>


Oracle V6.0 has two tables for constraint: constraint_defs and constraint_columns.

 desc constraint_defs

 Name                            Null?    Type
 ------------------------------- -------- ----
 OWNER                           NOT NULL CHAR(30)
 CONSTRAINT_NAME                 NOT NULL CHAR(30)
 CONSTRAINT_TYPE                          CHAR(1)    <<
 TABLE_NAME                      NOT NULL CHAR(30)
 SEARCH_CONDITION                         LONG
 R_OWNER                         NOT NULL CHAR(30)
 R_CONSTRAINT_NAME               NOT NULL CHAR(30)

how many types are defined for CONSTRAINT_TYPE?

I found that at least two types P and C. However, there is no explanation written in the DBA Guide.

Does anyone know what these mean?

thanks/david

-- 
David So			Internet: david.so_at_Software.Mitel.COM
Mitel Corp.
350 Legget Drive, Kanata, Ont.  Phone: (613) 592-2122 x3018
CANADA K2K 1X3         		Fax:   (613) 592-4784
Received on Fri Feb 12 1993 - 22:32:50 CET

Original text of this message