"No" and "No".
The absolutely maximum #/columns or maximum #/rows in a database: "it depends". For example, in MySQL 5.0:
In practice, however, any "reasonable" design for just about any common relational database can scale up as much as you want it to (or to as much disk, CPU and hardware as you can afford - whichever comes first
In general, "how many columns in a row" will depend on your DATA MODEL. Not on any limitation in the database.
So how many columns is "enough"?
A good rule of thumb is to "normalize
" your database to at least 3NF
'Hope that helps .. PSM