In my application i'm creating (applications user defined) dynamical tables inside SQL Server. Here is the E-R diagram for creating dynamical tables.
After dynamical table is created, and data is loaded, application converts dynamical table to static table witch is just ordinary table in SQL Server for easy querying, indexing, etc
If structure change in dynamical Table, application automatically recerate static table. Structure of dynamical Table changes rarely. This solution works fine in production.
Someone told me, this is anti pattern for creating dynamical tables. If this is anti-pattern, how do you suppose to create dynamical tables in SQL? What would be better solution for easy querying, indexing,etc, than creating static table?
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.