Re: More than 254 cols in table?

Kent Milligan (kmill_at_hawkeyes.rchland.ibm.com) wrote:
: In article <D4qJHA.FKM_at_freenet.carleton.ca>, ah513_at_FreeNet.Carleton.CA (Doug Harris) writes:
: |> In a previous posting, Steve Edelstein (74160.645_at_CompuServe.COM) writes:
: |>
: |> At least Oracle is one of the better ones at 254.
: |> --

: I think the 254 limit pales in comparison to the 8000 column limit

Oracle Rdb (formerly DEC Rdb) supported 2K columns in V3 if I recollect and InterBase allows 20,000 per table (row size max of 32 excluding blob fields).

: supported by DB2/400. I know of a couple of our customers
: that are well over 254 columns, but my mind is drawing a blank at
: the business process that requires this at the moment.

We have written systems taken to BCNF and still had to have 150+ attributes. One in particular was for the Curator systems for the Canadian Museums of Nature where they collect large amount of attribute data for specimens in their collections.

Both SQL Server and Oracle seem to have this 255/254 limit.

--
Nigel Campbell		  Voice: (613) 738-1338 ext 3016    P.O. Box 9707
Desktop Division            FAX: (613) 738-0002             3755 Riverside Dr.
Cognos Incorporated	    MCI: nigel campbell || 3074729  Ottawa, Ontario
UUnet: nigelc_at_cognos.COM                                    CANADA  K1G 3Z4