Question

Is there a limitation in the amount of attributes to be used in an entity?

2

For a static questionnaire form I want to use one entity with several answer possibilities, so I need approximately 100 attributes in this entity. Some enumerations and string values. Is there a limitation in the Modeler or in the database I use (MS SQL 2005)?

asked 2011-04-14

Pieter Stolp

3 answers

Samet Kaya · Answer 1 · 2011-04-14

We had a entity with 276 attributes (don't ask why). This worked for us, this was a postgresql db. So 100 attributes in your entity is not a limitation in the modeler. See this for more info on MS SQL

Fedor Klinkenberg · Answer 2 · 2011-04-14

At the moment we do have an entity with approximately 170+ attributes (questionnaire as well) and are using the same application database. We haven't experienced any problems.

Sebastiaan van den Broek · Answer 3 · 2011-04-14

SQL Server has a limit on the total amount of characters you can use in column names in a particular table, so yeah you can make an entity with 100 attributes but don't make the attribute names too long.