I'm in the airline game. 379 columns is the widest table that I can find in our production DB2 sub-systems - a highly denormalised table as I'm sure you can imagine. Perhaps someone like FedEx or UPS may have requirements to go real wide for their warehousing apps.
Nothing I can find in this big shop goes anywhere near the proposed limits. rayB -----Original Message----- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Friday, 18-Mar-2005 02:19 To: sqlite-users@sqlite.org Subject: RE: [sqlite] Proposal: limit the number of columns in a table to2000. On Thu, 2005-03-17 at 09:09 -0600, Fred Williams wrote: > BTW, Most of the "enterprise" database engines I have worked with have > had either published or "stealth" column count limits. All those that I > remember were below 2000. But I must admit I have not worked with any > of the current releases of the "big boys." > I used google to dig up the column count limits on some common database engines: DB2 255 Oracle 1000 SQL Server 1024 PostgreSQL 1600 MySQL 3398 Informix 32767 -- D. Richard Hipp <[EMAIL PROTECTED]>