Hello there can anybody tell me if there are any limits on the number of fields that a mysql table have? As i have a script which dynamically creates tables for a database driven website an i am finding that a significant proportion of table are not created where there are a large number of fields, i havn't pinned down exactly where the threshold of creatabilty is but it is around the 100 mark. All the tables have field of type varchar(20) and i am currently using version 3.23.35 beta Any thoughts or insights would be kindly received Kind Regards Paul [EMAIL PROTECTED]