constraint type
From: David So <davids_at_Software.Mitel.COM>
Date: 12 Feb 93 21:32:50 GMT
Message-ID: <14010_at_davids>
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-4784Received on Fri Feb 12 1993 - 22:32:50 CET