Re: using multiple subtables efficiently

From: lindawie <lindawie_at_my-deja.com>
Date: Wed, 26 Sep 2001 07:02:35 GMT
Message-ID: <f4fs7.2500$j57.611394_at_paloalto-snr1.gtei.net>


Joe,

> There is no such term as "subtable' in SQL.

Sure there is. "Subtable" may not be a keyword but ANSI SQL supports the concept of subtables and supertables. Check out "SQL-99 Complete, Really", p 530. Or the SQL-200n working documents, section 4.16.2 "Referenceable tables, subtables, and supertables".

Linda

"--CELKO--" <71062.1056_at_compuserve.com> wrote in message news:c0d87ec0.0109251709.4eec951e_at_posting.google.com...
> >> I'm pretty much a novice at database design. <<
>
> It shows <g>. Tables have rows and not records -- the difference is
> critical. There is no such term as "subtable' in SQL. And you did
> not post any DDL, so people trying to help you have to make stupid
> wild ass guesses about what you are doing.
>
> >> Table A holds general product information and the subtables hold
> product-specific information. <<
>
> CREATE TABLE Products
> (upc DECIMAL (10,0) NOT NULL PRIMARY KEY,
> ...);
>
> CREATE TABLE WetStuff
> (upc DECIMAL (10,0) NOT NULL
> PRIMARY KEY
> REFERENCES Products(upc)
> ON DELETE CASCADE
> ON UPDATE CASCADE,
> alcohol_percentage DECIMAL(5,4) NOT NULL DEFAULT 0.0000,
> ...);
>
> Etc.
Received on Wed Sep 26 2001 - 09:02:35 CEST

Original text of this message