What is the max number of custom fields allowed in SugarCRM -

i have searched on internet find out. gathering statistical information on clients , vendors. each field contain many different types of data character data (varchar(max)).

sugarcrm places no limits on number of custom fields can have. however, database being used have limits. example, mysql have limit of 4095 columns (4096 minus default id_c column in custom table). keep in mind real limit max row size if need hundreds of columns sure define small of column size can.

more info on mysql limits can found here: https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html

if ever run max can create new module , 1-to-1 relationship module need more fields for.