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
S
Subham Dixit
said
about 2 months ago
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-
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-
Michael_bartley
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!
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.
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstSubham Dixit
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.
Michael_bartley
thank you for the quick response. Super helpful!
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 263 topics