Start a new topic
Discussions xDM xDM - Model and Application Design
Answered

Column count Limiter within an Entity?

Hi there, just out of curiousity, is there a limit to the number of columns that can be created within a single entity?  That question came up and I couldnt answer.....thanks!

Best Answer

Hello Michael,


It is totally dependent on the DB that you are using which will create the columns in the table as much as the attributes you define in the entity, for example-

https://www.postgresql.org/docs/current/limits.html



For oracle-

There's a hard limit of 1,000 columns per table in Oracle Database 


For SQL Server-

https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16


Thanks.

2 CommentsSorted by Oldest First
Answer

Hello Michael,


It is totally dependent on the DB that you are using which will create the columns in the table as much as the attributes you define in the entity, for example-

https://www.postgresql.org/docs/current/limits.html



For oracle-

There's a hard limit of 1,000 columns per table in Oracle Database 


For SQL Server-

https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16


Thanks.

thank you for the quick response.  Super helpful!

Login to post a comment
More topics in xDM - Model and Application Design
See all 275 topics
Help Desk Software by Freshdesk