Garry Posted November 3, 2021 Report Share Posted November 3, 2021 How many data fields or columns is allowed per table? Quote Link to comment Share on other sites More sharing options...
0 KlisaN137 Posted November 3, 2021 Report Share Posted November 3, 2021 For the columns in a table in SQL, there is a maximum limit of 1024 columns in a table, I imagine same applies here. Quote Link to comment Share on other sites More sharing options...
0 Kurumi Posted November 3, 2021 Report Share Posted November 3, 2021 Hi @Garry - the maximum number of fields in a table is 1023 fields. For best practice, try limiting fields to about 150. See this reference: https://howto.caspio.com/tables-and-views/table-and-database-design/ Quote Link to comment Share on other sites More sharing options...
0 NiceDuck Posted November 20, 2021 Report Share Posted November 20, 2021 Personally, I think it is better to place my data on multiple tables and just linked them on via view set with Inner Join. It is a bit hassle to fill up since you will need multiple forms but saves me from losing everything when one of them got messed up. Quote Link to comment Share on other sites More sharing options...
Question
Garry
How many data fields or columns is allowed per table?
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.