File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
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.
 
Consider Paul's rocket mass heater.
 
subject: How many fields in one Table