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

Home -> Community -> Usenet -> comp.databases.theory -> Foreign superkey support

Foreign superkey support

From: Jon Heggland <jon.heggland_at_idi.ntnu.no>
Date: Mon, 07 Aug 2006 14:14:55 +0200
Message-ID: <eb7ao5$vn3$1@orkan.itea.ntnu.no>


Are there any DMBSs apart from Dataphor that support foreign superkeys without undue hassle? SQL systems support them in that a superkey may be declared UNIQUE, and thus referred to by a foreign key, but I'm looking for more explicit support.

Or more generally, are there any DBMSs that support inclusion dependencies (apart from the special case of foreign keys, naturally) directly?

Or for that matter, how widespread is multi-relvar constraint support (apart from foreign keys)? As far as I know, neither Oracle nor MSSQL support SQL ASSERTIONs. Are there any DMBSs that do?

-- 
Jon
Received on Mon Aug 07 2006 - 07:14:55 CDT

Original text of this message

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