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
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply 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
posted private message
0
Quote
How man fields can contain in on table ..

Akshayan...
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

I like...
Eclipse IDE Hibernate Java
posted private message
0
Quote
It varies by database. Read your database documentation to find out.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Ankur Sharma
Ranch Hand

Joined: Dec 27, 2005
Posts: 1234
posted private message
0
Quote
As in MS Access it can contains 64536 Fields.
Maximilian Xavier Stocker
Ranch Hand

Joined: Sep 20, 2005
Posts: 381
posted private message
0
Quote
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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: How many fields in one Table
 
Similar Threads
retrieve all the tables from a database
JTable+JPanel Parent Table and Child Table
how to update only the modified field values
its very very urgent
how to select from a row from a database using an id