[AccessD] Maximum number of columns in a table ?

Oleg_123 at xuppa.com Oleg_123 at xuppa.com
Wed Feb 5 13:45:01 CST 2003


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/





More information about the AccessD mailing list