Wortz, Charles
CWortz at tea.state.tx.us
Thu Feb 6 13:21:00 CST 2003
Oleg, If you want to be a spreadsheet developer and not a database developer, then continue with your spreadsheet thinking. But if you do want to be a database developer, please follow Francisco's advice. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us (SELECT * FROM users WHERE clue > 0) -----Original Message----- From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] Sent: Thursday 2003 Feb 06 13:11 To: accessd at databaseadvisors.com Subject: Re: [AccessD] Maximum number of columns in a table ? Importance: Low Francisco, right now we have column fields 2m(onths) 3, 4-6, 7-12, >2y (years which is 13 - 24) and <2y (goes up to 30 years)) Now they want a field for each individual monts; I think that creating a table with roughtly 70 fields would be the most painless solution (and from it a query with original fields - 4-6, 7-12, and reling it as datasource for reports) > 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 > : > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com ----------------------------------------- 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