Francisco H Tapia
my.lists at verizon.net
Thu Feb 6 12:14:00 CST 2003
Oleg, 70 fields? I recommend reviewing the benefits of normalization, specifically BCNF which is a derived from 3NF http://databasejournal.com/sqletc/article.php/1443021 more hits on google: http://tinyurl.com/5g4v -Francisco http://rcm.netfirms.com ----- Original Message ----- From: "Drew Wutka" <DWUTKA at marlow.com> To: <accessd at databaseadvisors.com> Sent: Wednesday, February 05, 2003 3:47 PM 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 :