Jim Dettman
jimdettman at earthlink.net
Thu Feb 6 12:44:01 CST 2003
Oleg, Those are SQL spec's. JET's are different, but still has no limit for the number of rows in a table. Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Oleg_123 at xuppa.com Sent: Wednesday, February 05, 2003 2: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