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