aspose file tools*
The moose likes JDBC and the fly likes How many Column ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How many Column ?" Watch "How many Column ?" New topic
Author

How many Column ?

Priyakant Charokar
Ranch Hand

Joined: May 08, 2004
Posts: 58

how many columns can a database table have??


SCJP, SCWCD, SCMAD, SCEA, OCPJP 7, CSM
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 39386
    
  28
Fewer than 984951984945621984651321984621216549546320306549463203068.

This MySQL link might be more useful. I suspect it varies from program to program.
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3710
    
    5

All database tables can have a maximum of 100 columns. Actually thats not true, but if you're ever in a situation where you have more than 100 columns you screwed up.
[ December 14, 2008: Message edited by: Scott Selikoff ]

My Blog: Down Home Country Coding with Scott Selikoff
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How many Column ?