[AccessD] Maximum number of columns in a table ?

Klos, Susan Susan.Klos at fldoe.org
Thu Feb 6 15:42:35 CST 2003


Yes, the limit is 255 for both tables and queries.  It took me a while to
figure out how come I was not getting all the fields from the table I was
importing.  Turns out there are 262 fields in the original table.  I got 255
and it stopped importing.

-----Original Message-----
From: Drew Wutka [mailto:DWUTKA at marlow.com]
Sent: Wednesday, February 05, 2003 6:48 PM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Maximum number of columns in a table ?


I believe the number of fields in a table is 255....I am assuming it's the
same for a query.

Drew

-----Original Message-----
From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
Sent: Wednesday, February 05, 2003 1:44 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Maximum number of columns in a table ?


I need to feet around 70, can I ? I found this on google, but somehowi
don't trust it; o limit on rows ??
------------------------------------

Maximum number of rows per table No Limit

Maximum number of tables per database No limit

Maximum number of tablespaces per database 32767

Maximum number of devices 32767

Maximum storage capacity 70 TB

Maximum row size (excluding BLOB & FO columns) 3992 bytes

Maximum number of columns per table 252

Maximum number of columns per index 16

Maximum number of journal files per database 8

Maximum length of table/column name 18 bytes

Maximum number of tables per join 31

Maximum number of savepoints per transaction 32

Maximum cache memory 2GB



-----------------------------------------
Send a Xuppa Valentine to Your Sweetheart today!
http://www.xuppa.com/greet/


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list