aspose file tools
The moose likes JDBC and Relational Databases and the fly likes How many fields in  one Table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How many fields in  one Table" Watch "How many fields in  one Table" New topic
Author

How many fields in one Table

Akshayan Venkatesh
Greenhorn

Joined: Apr 13, 2006
Posts: 26
How man fields can contain in on table ..

Akshayan...
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

It varies by database. Read your database documentation to find out.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Shaan Shar
Ranch Hand

Joined: Dec 27, 2005
Posts: 1249

As in MS Access it can contains 64536 Fields.
Maximilian Xavier Stocker
Ranch Hand

Joined: Sep 20, 2005
Posts: 381
Originally posted by Ankur Sharma:
As in MS Access it can contains 64536 Fields.

Errr. which version would this be? Access 2002/XP is 255 fields max.

64536 is the maxsize of an Access clob field.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How many fields in one Table
 
jQuery in Action, 3rd edition